URGENT!! need to remove space from a text

  • Thread starter Thread starter SMILE
  • Start date Start date
S

SMILE

Hello

I need an urgent help to solve my problem.

I have a text field for bar code for items. It is as follows
3 04824 753512 8

I want it to be changed the same by removing the space in between and
copied as 3048247535128

someone help me fast.. . running out of time ...

Thanks
toms
 
Hi Toms
If you want a formula, try
=SUBSTITUE(A11," ","") -> result will be text
If you like to calculate with the result use
=SUBSTITUE(A11," ","")*1

HTH
Frank
 
Thank you Frank

Though the spelling (SUBSTITUE) was wrong, I got it.


Actually I solved that by
LEFT(A1,1)&MID(A1,3,5)&MID(A1,9,6)&MID(A1,16,1)

but SUBSTITUTE was something new for me...

Thanks for giving me new idea...
Thanks a millon
Toms
 
Edit / Replace / Replace what = (Type a single space), Replace with = (leave
blank)

If you then need the data converted from text to numeric, copy an empty cell,
select all the data and do Edit / Paste Special / Add.
 
Back
Top