Removing a space in a numeric string

C

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

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top