how do I create a formula to seperate name into two cells (last, .

G

Guest

Is there a formula to seperate a name in one cell (last, first) and make them
into 2 cells?
 
N

Norman Jones

Hi Jobby,

You could use tht Text To Columns feature.

With the name cells selected, try:

Data | Text To Columns | Delimited | Next | Select appropriate
delimiter |
Next | Next | Finish
 
R

Ragdyer

The most direct way is to use "Text To Columns", since this procedure
produces the actual data in adjoining columns, with *no* underlying
formulas, which may have to be eliminated, going forward.

Select the column of names, then:
<Data> <TextToColumns>, and make sure that "Delimited" is checked.
Then, <Next>,
Now, check whatever your delimiter is, "Space or Comma", then,
<Finish>.

You should now have your names separated into 2 or 3 columns, where you can
do whatever.
 

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

splitting up information in a cell 1
What formula will take a name in one cell (last name,first name) . 2
seperate components of a whole address entry 10
Seperate text into two cells 4
VBA Excel partial cell compare to another cell 0
Excel VBA 1
determining the greater of three or more numbers 1
Reverse concatenate 3

Top