Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extracting numbers
I recently had to extract the numerical data from the text for
the cells in a fairly long column. I know there are available user functions based on a loop and ISNUMBER but has anyone got a favorite method using built-in worksheet or formatting functions? Since my problem was something I don't expect to have to do frequently, I simply copied the column to Word and used its wild-cards in Replace instead of Excel's pitifully small list. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extracting numbers
Depending on the regularity or pattern in thee imported text, you might be
able to use Text to Columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "James Silverton" wrote in message ... I recently had to extract the numerical data from the text for the cells in a fairly long column. I know there are available user functions based on a loop and ISNUMBER but has anyone got a favorite method using built-in worksheet or formatting functions? Since my problem was something I don't expect to have to do frequently, I simply copied the column to Word and used its wild-cards in Replace instead of Excel's pitifully small list. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Extracting numbers
Hello, Jon!
You wrote on Sun, 10 Sep 2006 21:24:07 -0400: I did the sensible thing and posted also to m.p.excel.misc and got some good suggestions. One of the problems was that the spacing and position of the numbers was not fixed. Thanks again! James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting digits to the right of a decima point | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |