Excel; addresses in single column; merge?

November 28, 2011 at 02:42:12
Specs: Windows XP
Hello! Apologies from a computer gumby. I am a PhD researcher conducting a recruitment mailout, with an excel participant database of 300 names. Participants' addresses have been entered (in entirety from house number to ZIP/postcode) in a single column.

I need to conduct a mail merge, but cannot find a way (short of changing each cell individually) to reformat the addresses.

Current address format: 32 Brook St, Lee Park 3111

Required format: 32 Brook St,
Lee Park 3111

Had I been forward-thinking, I would have entered data in separate columns :-(

Sincere thanks for any advice.


See More: Excel; addresses in single column; merge?

Report •

#1
November 28, 2011 at 11:33:15
If all you want to do is separate the addresses into 2 columns, and not move the city underneath the house address, try:

Data...Text To Columns...Delimited...Next...Comma...Finish

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


Report •
Related Solutions


Ask Question