Converting variable text strings to numeric

R

Richgard53

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?
 
B

Biff

Hi!

Try using Find/Replace

Select the range
Goto Edit>Replace
Find What: enter a space by hitting the space bar
Replace With: nothing, leave this blank
Replace All

Biff
 
Top