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?