Closed Thread
Results 1 to 5 of 5

Space before first name in mail merge

  1. #1
    Registered User
    Join Date
    07-20-2009
    Location
    Roanoke, Tx
    MS-Off Ver
    Excel 2003
    Posts
    24

    Space before first name in mail merge

    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?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Space before first name in mail merge

    hard to tell without seeing the Excel file and the Word merge document

  3. #3
    Registered User
    Join Date
    07-20-2009
    Location
    Roanoke, Tx
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Space before first name in mail merge

    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.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Space before first name in mail merge

    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.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Space before first name in mail merge

    Duplicate post, thread closed.

    Please continue in your prior thread.
    Entia non sunt multiplicanda sine necessitate

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1