Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting variable text strings to numeric
I've imported some word tables into excel, the 'numbers' have spaces instead
of commas and consequently are read as text. The 'numbers' vary from single integer to millions For example 1 101 335 293 207 23 113 101 19 While I can use the left, mid and right functions for the millions that formula is unworkable for other numbers. Any ideas, or do I have to get a VB programmer to write a function for me? |
#2
|
|||
|
|||
Hi!
Try using Find/Replace Select the range Goto EditReplace Find What: enter a space by hitting the space bar Replace With: nothing, leave this blank Replace All Biff "Richgard53" wrote in message ... I've imported some word tables into excel, the 'numbers' have spaces instead of commas and consequently are read as text. The 'numbers' vary from single integer to millions For example 1 101 335 293 207 23 113 101 19 While I can use the left, mid and right functions for the millions that formula is unworkable for other numbers. Any ideas, or do I have to get a VB programmer to write a function for me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable control tip text | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Converting Text into a Numeric Value and Totalling | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions |