In my excel Column A I had a space before the first name in every row. I used =trim(A1) and that fixed it but when i merged it into mail merge......there is now a space before the name....not sure if this is excel or word.......help?
In my excel Column A I had a space before the first name in every row. I used =trim(A1) and that fixed it but when i merged it into mail merge......there is now a space before the name....not sure if this is excel or word.......help?
hard to tell without seeing the Excel file and the Word merge document
this is the most ridiculous thing!
This is what my excel looks like:
A1 B1 C1 D1 E1
Ron & Iva Smith 1098 Rain St Whitney Tx 76626
This is what my POS Mail Merge in Word looks like:
Ron & Iva Smith
1098 Rain St
Whitney Tx, 76626
My address and city/state/zip are aligned properly but my name line is a space to the right! How the hell to I fix this because I have been dealing with this now for 3 hours! I am sorry to be upset but this **** sucks! and I am not upset with you guys.
read my previous reply and my reply to your other post about the same topic
Last edited by teylyn; 10-31-2009 at 03:38 PM.
Duplicate post, thread closed.
Please continue in your prior thread.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks