Removing Space from Number Copied n2 XL from HTML

[cellbee]

Does anyone know how to remove the pesky space from a numeric string that has been copied from a web page and pasted into an excel spreadsheet?

Thanks!

[oldchippy]

Go to Edit > Find Replace

[Paul]

If the space is at the end of the number, you should be able to use

=trim(a1)

If the space is in the middle somewhere, you can use

=substitute(a1," ","")

[cellbee]

the space is at the end of the number but for some reason even with the trim command the space remains.

[Paul]

How about

=CLEAN(A1)

This will remove a handful of non-printing characters.

If this fails, you can probably do as OldChippy suggested and use Find/Replace. The trick is you'll have to go into one of the problem cells and select that last invisible character. Copy that character and paste it into the "Find What" box in the Replace window. In the "Replace With" box, do nothing (leave blank). Click Replace All and it should get rid of those non-printing characters.

Let us know..