separating text into different columns

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a column with first name, last and Mi all separated
by a space.

I need a formula that will take the first last and mi and
put them in their own columns.

P
 
Thats a big problem...

xxx x. xxxxx - entry like this would be fine
(fname init last)

but what if,

john ray c. del sol ???

pretty hard
 
How would you do it with the formatting you are showing
below? This would get me close enough

P
 
what im saying is...
if you have a unique indicator or separator aside from
spaces, it would be a bit easier.

the problem here, is you dont know if a particular person
has two given names...

using data > text to column will not work for you
unless all first names have the same length
 
Paul

Try Data>Text to Columns.

De-limited by space.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Separate First Name MI and Last Name into three Cells 3
sorting data by a certain attribute 2
Formula for names 6
Separating Text 2
Text to columns question 5
Split column contents (de-concantenate) 7
Need to alphabetize data from separate cells within same row 2
Text Separation Function 6

Back
Top