+ Reply to Thread
Results 1 to 5 of 5

Removing spaces in a field.

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Removing spaces in a field.

    I'm having to use the wizard to do mail merges with excel/csv files. I need to know how to remove spaces in a filed. For example if we have 12 spaces for 'First Name' and have Bob there Word treats the remaining 8 spaces as being populated. We can't change how the csv file is created but need to remove any unwanted null/blank spaces within certain fields. Any ideas?

  2. #2
    Forum Contributor
    Join Date
    06-23-2010
    Location
    Iowa, United States
    MS-Off Ver
    Excel 2007
    Posts
    145

    Re: Removing spaces in a field.

    Try doing a find and replace. Hit the space bar once under "Find What" and leave "Replace With" blank. Be sure to go under Options and make sure the "Match Case" box is clicked. Let me know if this works for you.

    Steve
    A VBA novice, excited to learn!

  3. #3
    Registered User
    Join Date
    06-11-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Removing spaces in a field.

    Hey Steve0492, At which point do I do this?

  4. #4
    Registered User
    Join Date
    06-11-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Removing spaces in a field.

    Steve0492, Never mind. That did the job. Can't tell you how much I appreciate it.....

  5. #5
    Forum Contributor
    Join Date
    06-23-2010
    Location
    Iowa, United States
    MS-Off Ver
    Excel 2007
    Posts
    145

    Re: Removing spaces in a field.

    Always glad to help rick!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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