Make sure the column to the right is blank (or insert a column)

select the column with the data and do Data=Text to Columns

Select delimited and space as the delimiter.

If you have last names with embedded spaces, this will not work.

You could use a formula
B2
C2
=trim(left(Trim(A2),len(trim(A2))-1)) =Right(Trim(A2),1)

drag fill the formulas down the column.

Regards,
Tom Ogilvy

ccj wrote in message
...
I receive a worksheet weekly that comes with both the last
name and first initial in the same field (jones c). I
would like to have the last name in one field and the
first initial in another field. How would I do this?
Thanks