seperating a cell that contains 'Title' 'First Name' 'Last Name' into 3 cells

V

Vix

If a cell in Excel contains the following " Miss Victoria
Jones" or "Mr. Tom Jones"

Is there a formaula or easy macro I could run that would
separate the three words into 3 separate cells?

Thanx
 
F

Frank Kabel

Hi Vix
if all your entries consist of three words (e.g. no middle names) then
one way would be to use 'Data - Text to columns' and choose the space
as delimiter

HTH
Frank
 

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

Grouping Names in Mail Merge 0
Parsing full name into salutation, First, middle, last, Suffix 1
parsing a full name out into Last, First, Middle 2
Remove & extract name in one cell 7
Separate First Name MI and Last Name into three Cells 1
Excel to Word to PDF workflow 1
Formula for Matching Names and Conditional Formatting! 6
Creating Labels Over 3-Up Image 2

Top