Always wanted to know how to do that...it is very useful....thanks a bunch
Gary's student....works like a charm

"Gary's Student" wrote:

Assuming that your data is in column A and is all of the form title, space,
first_name, space, last_name, then use Data Text to Columns to fill column
B with the title, fill column C with the first_name, and fill column D with
the last_name.

Enter
=D1&", "&B1&" "&C1
in cell E1 and copy cown
--
Gary's Student


"excelnewbie" wrote:

I am extracting one single column from word where the person's name is
written "Mr. John Smith." Is there any way in excel to have it appear as
"Smith, Mr. John" It can be in the same column but I need to be able to sort
by the last name - not the title!