+ Reply to Thread
Results 1 to 3 of 3

remove random spaces in a text string

Hybrid View

  1. 07-10-2008, 02:33 PM #1
    mariusescu
    mariusescu is offline
    Registered User
    Join Date
    06-29-2007
    Posts
    18

    remove random spaces in a text string

    I have a column with postal codes that come in two formats, with and without a space in the middle (L5N3M0, L5N 3M0).
    I'd like to get rid of this space without having to go through it manually. So I'd need a function that does that, and I'd like to use this function in a macro.

    Any help is much appreciated

    thank you
    m
    Reply With QuoteRegister To Reply
  2. 07-10-2008, 02:38 PM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    The REPLACE function can be used to strip text.

    replace(activecell.Value," ","")
    or you could combine JOIN and SPLIT
    join(split(activecell.Value," "),"") , activecell.Value
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 07-10-2008, 03:32 PM #3
    mariusescu
    mariusescu is offline
    Registered User
    Join Date
    06-29-2007
    Posts
    18

    remove random spaces in a text string

    thanks a million Andy
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1