View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tim
 
Posts: n/a
Default choose a particular word in a string

Thanks guys. All very helpful.


"Pete_UK" wrote:

If the names are separated by a single space, then you can highlight
the column and use Data | Text-to-columns, specifying Delimited data
with space as the delimiter. You can specify where the data is to be
written to, if you want to keep the original column of names.

Hope this helps.

Pete