Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
splitting contents of a cell | Excel Discussion (Misc queries) | |||
splitting out cell contents | Excel Discussion (Misc queries) | |||
Splitting cell contents | Excel Discussion (Misc queries) | |||
Splitting cell contents | Excel Discussion (Misc queries) | |||
Splitting the contents of a cell | Excel Discussion (Misc queries) |