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.
|