View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TonyM TonyM is offline
external usenet poster
 
Posts: 10
Default Extracting data from a single cell

Hi

If your data is pretty uniform you can use DataText To
Columns to extract what you need into seperate cells.
Otherwise it sounds like a vba routine but you would have
to post an example before anyone can help.


-----Original Message-----

Hello

I am using Excel 2002, I have 4000+ records each cell has

words dates
and cost in them. I would like to extract the cost and

the time
elements from the cells can any one help. Am I in the

right
forum?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from

http://www.ExcelForum.com/

.