Remove an extra space after a number.
the new excel wouldn't let me do that.
"New" Excel means Excel 2007?
Sometimes this works:
Select the range in question
Goto Data tabData Tools groupText to Columns
Just click Finish
--
Biff
Microsoft Excel MVP
"Hummingbird" wrote in message
...
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.
|