Hi Tony,
A macro solution would avoid the messy clean up afterwards
associated with worksheet formulas, if you want a permanent separation.
Rearranging Data in Columns
Separate first word (term) from remainder of cell (#septerm)
http://www.mvps.org/dmcritchie/excel/join.htm#septerm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TONY" wrote
want to strip off the first word of the text string and place this into a
different column leaving the rest(minus this one word) in the original
column cell.