Converting variable text strings to numeric

[Guest]

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?

 

[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