Separating Names & Last Names

  • Thread starter Thread starter Fernando Gomez
  • Start date Start date
F

Fernando Gomez

I have a long list of Las Names and Names coming from a database, in this
way
Russel...Mark (the dot comes in different numbers from 2 to 6), what I am
trying to do is with a formula, separate last name and put that in a column
& name put in a different column.

Thanks in advance for your help
 
Fernando,

Go to Data>Text To Columns
Choose the Delimited button
Next
Select Other and input an other character as . (dot)
Select 'Treat Consecutive Delimiters as one'
Finish

That should do it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Fernando,
I have a long list of Las Names and Names coming from a database, in this
way
Russel...Mark (the dot comes in different numbers from 2 to 6), what I am
trying to do is with a formula, separate last name and put that in a column
& name put in a different column.
Click to expand...

Instead of using a formula, I'd use Data > Text To Columns to split them,
providing the '.' as the delimiter and telling it to ignore duplicates.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
Back
Top