URGENT!! need to remove space from a text

[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

 

[Frank Kabel]

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

 

[SMILE]

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

 

[Frank Kabel]

Hi Toms,
sorry for the misspelling and thanks for the thanks
Frank

 

[Ken Wright]

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.