LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove space in front of number in a cell? Barcelona Excel Worksheet Functions 5 September 18th 08 02:43 PM
Extra Space With Buttons tepermanj Excel Discussion (Misc queries) 2 January 4th 08 09:19 PM
Extra Line Space Leesa Excel Discussion (Misc queries) 1 May 24th 05 09:37 PM
Extra Line Space Leesa Excel Discussion (Misc queries) 0 May 24th 05 08:49 PM
Extra line space JJ Excel Discussion (Misc queries) 1 February 18th 05 11:32 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"