Split single cell into multiple cells

Discussion in 'Excel' started by Adrienne, Apr 19, 2017.

  1. Adrienne

    Adrienne

    Joined:
    Apr 19, 2017
    Messages:
    2
    Likes Received:
    0
    Could some one please help with my memory :) I believe there is a way (formula) to take a cell that contains (for example) FirstName LastName (separated only by a space) and split it into to 2 cells - FirstName in one and LastName into the next?
    TIA
     
    Adrienne, Apr 19, 2017
    #1
    1. Advertisements

  2. Adrienne

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    Hi Adrienne,
    TextToColumns is a built in Excel function which will do this for you.

    Just make sure you have a blank column to the right of your column with the names as it will put everything after the space into a column directly to the right of it. Then, highlight the column, go to the Data menu, and under data tools click text to columns. Click delimited and choose space as your delimiter. That should be it!

    I also wrote an article on how to do this exact thing if you run into any trouble you could use it for reference or leave another comment below.
    http://www.germanpearls.com/excel-text-to-columns-separate-names/
    Good luck!
    Amy
     
    Amy @ German Pearls, Apr 19, 2017
    #2
    Becky likes this.
    1. Advertisements

  3. Adrienne

    Adrienne

    Joined:
    Apr 19, 2017
    Messages:
    2
    Likes Received:
    0
    Thanks Amy! That was 100% what I needed.
     
    Adrienne, Apr 19, 2017
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. kr_kernel

    Hiding Cells

    kr_kernel, Apr 28, 2012, in forum: Excel
    Replies:
    1
    Views:
    740
    markwillium
    May 24, 2012
  2. lga3q
    Replies:
    1
    Views:
    677
    lga3q
    May 18, 2012
  3. dartanee

    All Shaded Cells print pure black

    dartanee, Jun 29, 2012, in forum: Excel
    Replies:
    1
    Views:
    1,164
    wdroom
    Jul 21, 2012
  4. annbc

    Visible cells

    annbc, Sep 15, 2013, in forum: Excel
    Replies:
    0
    Views:
    621
    annbc
    Sep 15, 2013
  5. Hwalker1
    Replies:
    2
    Views:
    570
    XLPadawan
    Jun 13, 2016
  6. DanM
    Replies:
    1
    Views:
    419
    XLPadawan
    Jun 13, 2016
  7. TryllZ
    Replies:
    4
    Views:
    290
    XLPadawan
    Jun 9, 2016
  8. jdoon5261
    Replies:
    5
    Views:
    298
    Becky
    Mar 6, 2017
Loading...