|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.