Removing a space in a numeric string

  • Thread starter Thread starter Chris
  • Start date Start date
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?
 
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.
 
Back
Top