Removing a space in a numeric string

[Chris]

I have imported a text or general field from another file
as follows 99 99.
I need to remove the space between the two sets of
numerics.
How do I do this?

 

[Norman Harker]

Hi Chris!

If you still want it as text:

=SUBSTITUTE(A1," ","")

If you want it as numeric:

=--SUBSTITUTE(A1," ","")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[MrvinGover]

Dont know how to answer your question but this string might be som
help

http://www.excelforum.com/t183077-