Remove spaces from my zip codes

highlight column & use Edit -> Replace -- What: [hit space] With: [enter nothing]

yes, I already tried that. And it did not work.

it tells me it can not find the data i am searching for.

Thats why I was stumped...

Anything else, or did I do something for it not to work?

Please help me... lol

If pasted from HTML, they are probably non-breaking spaces. Select the column, and in Find What, press and hold the Alt key, and on the NUMERIC keypad, type 0160

Then Replace All.

Originally Posted by shg

If pasted from HTML, they are probably non-breaking spaces. Select the column, and in Find What, press and hold the Alt key, and on the NUMERIC keypad, type 0160

Then Replace All.

Okay I tried the clean/trim and did not work.

So I tried this one but when I try to enter the 0160 while pressing down ALT, it just makes a beep sound for each mnumber i press down.

Any other ideas, or how to get this one to work?

I also added a sample of zipcodes in my list.

Thanks in advance,

Jason

both methods work, the alt 0160 you must use the number/numeric key pad not the top row
which i see SHG told you!
on a laptop you would have to activate the numbers which are in blue on certain letters

Try this formula :-

=TRIM(SUBSTITUTE(B2,CHAR(160),""))

infact

=SUBSTITUTE(B2,CHAR(160),"")

works since there are no spaces in your sample!