Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Splitting Text String into 2 Cells

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi.

    I am really hoping someone can help me with this one. I've used a Concatenate function before to join first and last names together into one cell, now I need to do the opposite.

    Wherever there is a space used within a cell, I want the program to recognise it and move the next word into a separate cell. Most values I have are First and Last Name ie. John Smith. But some are initials and names ie. J M Smith.

    Can someone please tell me how to divide text strings?

    Thanks in advance

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-13 09:05, nscobie wrote:
    Hi.

    I am really hoping someone can help me with this one. I've used a Concatenate function before to join first and last names together into one cell, now I need to do the opposite.

    Wherever there is a space used within a cell, I want the program to recognise it and move the next word into a separate cell. Most values I have are First and Last Name ie. John Smith. But some are initials and names ie. J M Smith.

    Can someone please tell me how to divide text strings?

    Thanks in advance
    In B2 enter:

    =SUBSTITUTE(A2,C2,"")

    In C2 enter:

    =RIGHT(A2,LEN(A2)-SEARCH("@",SUBSTITUTE(A2," ","@",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •