View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Atkins Jon Atkins is offline
external usenet poster
 
Posts: 3
Default Splitting cell contents

Hi

Could anyone offer any help on how to split the following into
seperate columns....
All data is in column A, and is formatted as: -

Baked Beans Buy Zeinz Products Today at 10:03:42am
Baked Beans Sell Maru Industries Today at 10:27:32am
Parsnips Buy The Farming Corp. Today at 11:23:57am
Parsnips Sell The Superstore Confed. Today at 12:05:09pm

I would like the text split into columns as: -

Column B Col C Col D Col E Col F ColG
Baked Beans Buy Zeinz Products Today at 10:03:42am
Baked Beans Sell Maru Products Today at 10:27:32am
etc

The text needs to be split around the common words of 'buy', 'sell',
'at' and 'today'. These words will always appear in the original
format.


Thanks for any help