Hi David,

With your data selected, try:

Data | Text to columns | Delimited | Next | Select the 'Space' option
| Next | Finish

If you need to do this programmatically, turn on the macro recorder and
perform the above manual operation.

This should provide code which can be adapted for general application.


---
Regards,
Norman



"giddne" wrote in message
...
I have cells with names to use in direct mail. The current format could be
many variations but I only need the first 3 names initials etc. such as
John
Doe or John W Doe. I am not interested in anything after that. Putting
it
in 3 separate cells would be ideal but 1 or 2 would also be acceptable.

Current formats include all of these:
Doe John
Doe John W
Doe John W JR
Doe John W & Doe Jane R

Appreciate your help. Love this site!!
David