Hi,
Hopefully somebody can help if this can be done at all.
I'm currently trying to complete a mailmerge with approx 6500 records but the addresses in approx half of the cells are formatted incorrectly (an unavoidable issue with data that's extracted from our own bespoke software) and inserts a comma after the house number of the street name. Example as below (false data used for confidentiality purposes) :
1 Mickey Mouse Street, Disneyland, Florida, FL1 2MM
3, Donald Duck Street, Disney World, Paris, PA1 2DD
5, Goofy Plaza, Goof Town, Goofsville, GG3 8GG
7 Minnie Mouse Road, Minnie Town, MM8 7MM
9 Yosemite Lane, Yosemite, YY5 7YY
What I'm looking to do is automatically remove the commas after the numbers in lines 2 and 3 in this example (eg so 3, Donald Duck Street becomes 3 Donald Duck Street in the same formate as the other 3 lines) thus enabling me to delimit by comma and mailmerge data into an MSWord doc.
The above examples only list 5 addresses but in reality there are 6500 so a manual trawl and correction is really out of the question.
If this can even be done could somebody advise how?
Thanks in advance and hope this request makes sense.
Andrew
Bookmarks