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
 
Top