Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting data from a single cell
Hello I am using Excel 2002, I have 4000+ records each cell has words date and cost in them. I would like to extract the cost and the tim elements from the cells can any one help. Am I in the righ forum?:confused ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting numbers and letters in a single cell to separate cells | Excel Discussion (Misc queries) | |||
Extracting Address data from single cells | Excel Worksheet Functions | |||
Extracting single piece of data | Excel Discussion (Misc queries) | |||
Extracting single piece of data | Excel Discussion (Misc queries) | |||
Extracting single piece of data | Excel Discussion (Misc queries) |