moving part of information from one cell to another...

G

Guest

Hello, Currently i have the first and last name combined in one cell, how can
i break this up to have the first name in a cell and the last name in another
cell?
thank you,
 
G

Guest

'Data'....'text to columns' ...'deliminated' and use the space between the
names as the delimiter.
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Bold part of combined cell 4
Sort by Last Name when name is combined 5
Seperating information in a cell 9
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
First, Last occurance of date in column 5
ALPHABETIZING! 2

Top