parsing field
 

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

parsing field
 

Select the values
Data-Text To Columns
Select the "Delimited" box <Next
Select "Space" as the delimiter (and de-select any others that may get
in the way (comma's for ex))
<Next etc.
This will split the names for you.
Depending on the makeup of the names you may have to do some "playing
around" If, for ex, the last name has a space in it, then XL will parse
it on the first delimiter it finds, which will split the last name.
Read the Help on the subject


--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.

parsing field
 

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