Results 1 to 9 of 9

Dividing string text into separate cells

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question Dividing string text into separate cells

    Hello everyone!

    I have about 4,000 names and they are all in one column, but in groups of 3's. Example...

    A1: JOHN DOE HUGH JACKMAN JANE SMITH
    A2: TARZAN ERNEST HEMMINGWAY SEAN CONNERY

    ... I'd like to separate them into three different columns but they are all different lengths with no common delimiter. Even the spaces between them aren't even. To get the names into columns E, F, and G, I used the LEFT function to get the first name. I used =MID(A1,LEN(E1),LEN(A1)-(LEN(G1)+LEN(E1))) to get the second name, but that will only work if I can figure out a way to get the third name into cell G.

    Any clues??? Thanks in advance!
    stinkstik
    Last edited by stinkstik; 04-25-2013 at 08:09 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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