Solved need to convert 1 column of address data to multiple columns

August 19, 2012 at 15:08:42
Specs: Windows 7, intel5750 2 ghz 3 gig rame
I have an address list in col A in excel
with a blank row between each address
I need to put them in up to 9 columns
name address1 address 2 etc
name col 1 through to postcode in col 9
postcode is last data of each address
not sure what to do
is there a macro available

See More: need to convert 1 column of address data to multiple columns

Report •


#1
August 19, 2012 at 16:32:07
✔ Best Answer
There is a feature in Excel known as Data...Text To Columns which is typically used to split long strings in one column into multiple columns.

Read the Excel Help files on that feature and see if it works for you.

If you need any further assistance with your specific situation, please click on the blue line at the end of this post, and after reading the instructions found via that link, post some examples of your data and we'll see if we can offer any other suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question