unwanted spaces in mail merge docs

Discussion in 'Microsoft Excel Misc' started by Guest, Nov 25, 2003.

  1. Guest

    Guest Guest

    Hi, how do I eliminate unwanted spaces before and after first and last names in mail merge doc
    so that I do not have to scan each address and delete spaces manually?
     
    Guest, Nov 25, 2003
    #1
    1. Advertisements

  2. Guest

    Peo Sjoblom Guest

    You can run a macro

    http://www.mvps.org/dmcritchie/excel/join.htm#trimall

    --

    Regards,

    Peo Sjoblom


    "kblaker" <> wrote in message
    news:D...
    > Hi, how do I eliminate unwanted spaces before and after first and last

    names in mail merge docs
    > so that I do not have to scan each address and delete spaces manually?
     
    Peo Sjoblom, Nov 25, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. caustin

    How to remove spaces in mail merge

    caustin, Jun 7, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    2,937
    caustin
    Jun 7, 2006
  2. Guest

    Excel docs not saving as excel docs

    Guest, Sep 11, 2006, in forum: Microsoft Excel Misc
    Replies:
    6
    Views:
    238
    Gord Dibben
    Sep 12, 2006
  3. austris

    Code launches Mail Merge but disables the Mail Merge

    austris, Oct 14, 2006, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    264
    austris
    Oct 14, 2006
  4. oldtimer43
    Replies:
    2
    Views:
    185
  5. ksf

    Unwanted spaces in merged cells

    ksf, Apr 22, 2009, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    167
Loading...

Share This Page