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/
.