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

  • Thread starter Thread starter Vix
  • Start date Start date
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
 
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
 
Back
Top