Remove an extra space after a number.
On Tue, 10 Mar 2009 13:46:20 -0700, Hummingbird
wrote:
I have a column of numbers. Each number has an extra space after the number.
Instead of 102.
It's 102 .
I tried using the =trim(cellRef) and then copying the values of that column
over to another column, but it kept the space after the nubmer.
I also tried a find and replace for just the space, but the new excel
wouldn't let me do that.
Help.
Did you get the numbers from an html document (web page)?
Try =substitute(cell_ref,char(160),"")
--ron
|