LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
splitting contents of a cell april Excel Discussion (Misc queries) 5 December 21st 09 06:55 PM
splitting out cell contents ksh Excel Discussion (Misc queries) 2 January 14th 08 06:14 PM
Splitting cell contents GARY Excel Discussion (Misc queries) 3 November 5th 07 11:53 PM
Splitting cell contents GARY Excel Discussion (Misc queries) 1 November 5th 07 06:58 PM
Splitting the contents of a cell Keith Excel Discussion (Misc queries) 7 September 21st 06 07:21 PM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"