Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.
    Regards,

    WidgetWonka
    Puuuureeee Imagination

    Comment


    • #3


      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

      Comment

      Working...
      X