Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: add a space, two spaces after the comma in a string of text

  1. #1
    Join Date
    19th May 2011
    Location
    NC
    Posts
    3

    add a space, two spaces after the comma in a string of text

    I need to add a space, two spaces after the comma in a string of text, applicable for all cells in column a only.

    example: doe, jk001254445
    need: doe, j k00125445

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    17th March 2011
    Location
    Atlanta, GA, USA
    Posts
    153

    Re: add a space, two spaces after the comma in a string of text

    This only works for the first comma. Multiple instances can be handled, but requires a more complex formula:

    =LEFT(D21,FIND(",",D21))&" "&MID(D21,FIND(",",D21)+2,1)&" "&RIGHT(D21,LEN(D21)-FIND(", ",D21)-2)

    The string doe, jk001254445 is cell D21 in this example.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,099

    Re: add a space, two spaces after the comma in a string of text

    If widget's solution does not fully meet your needs then:

    To get the most precise answers, it is best to upload a sample workbook (sensitive data scrubbed/removed) that shows a few manually created examples of the desired results.
    The structure and data types of the workbook must exactly match that of the real workbook. Include in the workbook a clear and explicit explanation of all requirements.The sample workbook only needs to contain enough data to illustrate the need to aid with developing the solution.

    How to edit your post or thread title or upload an attachment

    1. Click the EDIT POST in the gray band immediately below your post
    2. Click Go Advanced
    3. Edit the post or thread title
    4. To upload: scroll down to Manage Attachments
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: October 19th, 2011, 03:27
  2. Extract Text After Space In String
    By stevekirk in forum EXCEL HELP
    Replies: 6
    Last Post: October 6th, 2006, 09:43
  3. Space after comma in names
    By thiagarr in forum EXCEL HELP
    Replies: 4
    Last Post: June 16th, 2006, 07:42
  4. Detect space, underscore or semi-colon in text string
    By Maths Dude in forum EXCEL HELP
    Replies: 9
    Last Post: January 31st, 2005, 09:52
  5. Add Spaces to text String
    By ian in forum EXCEL HELP
    Replies: 4
    Last Post: May 15th, 2003, 23:49

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
  •  
porno