View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hummingbird Hummingbird is offline
external usenet poster
 
Posts: 5
Default Remove an extra space after a number.

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.