Results 1 to 8 of 8

Remove consecutive spaces and replace with single comma

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Remove consecutive spaces and replace with single comma

    Have a list of names. For a majority of names the cell will contain the persons last name; followed by 2 or more spaces; followed by the first name. What I would like to accomplish is to remove in case in which there are two or more consecutive spaces and replace all with a comma and single space. Example of output below

    original data "ANDERSON MICHAEL"

    replace with "ANDERSON, MICHAEL"

    Is this possible with a formula or do I need to use VBA. I have attached a small sample in column A and the desired results in column B.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove spaces and replace with comma.
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 01:01 PM
  2. [SOLVED] Concatenate rows into single cell, but remove last comma from row
    By djm601 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2013, 09:45 AM
  3. [SOLVED] Replacing double spaces with single spaces
    By EdWoods in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-15-2013, 01:20 AM
  4. Find and remove all text to the left of last comma (including comma) in a cell
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 08:47 AM
  5. Using the Replace to remove Spaces in a Number
    By TWent in forum Excel General
    Replies: 5
    Last Post: 05-09-2011, 02:34 PM
  6. replace the comma separator to a dot and dot to a comma at the same time
    By barkiny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2010, 05:42 PM
  7. How do I remove single spaces between words in spreadsheet?
    By spacecadet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2007, 11:50 AM
  8. [SOLVED] Remove single spaces
    By Bruno in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2005, 11:05 AM

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