Hi everyone
Really not sure how to do this in VBA or with a Macro, but here goes:
I have a column of information that I currently split out using a variety of queries in a worksheet (Office 365 version)
The basic format is like this (see attached example)
+++TOWN NAME (LLLNN) - [where L=a letter and N = a number]
These sit in column A
I need to show these in a new format in two separate columns, thus:
Column 2 - TOWN NAME
Column 3 - LLLNN
Currently using the queries as follows:
=RIGHT(A1,6) - to extract the final 6 characters which brings up LLLNN) in the result
Then, in the next column:
=RIGHT(A1,LEN(A1)-3) to remove the +++ from the cell data
...and then
=LEFT(C1,LEN(C1)-7) to remove everything but the town name from the data
and finally...
=LEFT(B1,5) to show the LLLNN section I need
It works fine, but I'm hoping to create a piece of code that will perform these functions down a variable length list in column A until it meets the first blank cell.
Any suggestions very, very welcome - am trying to wrap my head around VBA but it seems to be meeting a bit of a block (my somewhat dim brain!)