delete space between characters or numbers

  • Thread starter Thread starter jskang
  • Start date Start date
J

jskang

Does anybody know how to delete space between characters or number in a
cell?

Example 1 in a A1 cell 543 345 7575 and B1 cell 7984 6 34
and in A2 look like this 5433457575 and B2 cell 7984634

Example 2 in a A1 cell John David Smith and B1 cell Harry James
and in A2 or same cell A1 look like this JohnDavidSmith and B2 or same
cell B1 HarryJames.

Many thanks for your help

JSK
 
Hi JSK!

If you want text use:

=SUBSTITUTE(A9," ","")

If you want it as a number use:

=--SUBSTITUTE(A9," ","")

--
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.
 
Not the most efficient way to do "just" what you want...........but you
could do Data > Text to columns, using "space" as a delimiter to separate
the segments into different columns and then re-construct your strings using
the CONCATENATE function to make it all one continuous string of characters,
as you've requested, or you could put in hyphens, periods, multiple spaces,
etc.............like "543-345-7575",.........or "Smith, John David", or even
"Smith, David John".

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top