Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Remove an extra space after a number.

I'm guessing that "dot" that is at the end of your two sample lines is in
the cell. If so, select the column with those "extra space" entries, click
Edit/Replace from Excel's menu bar, put " ." (without the quote marks; that
is, type space and dot) in the "Find what" field and put "." (again, without
the quote marks; that is, just put a dot) in the "Replace with" field, then
click the "Replace All" button.

--
Rick (MVP - Excel)


"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.


Reply
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 10: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 19th 05 12:32 AM


All times are GMT +1. The time now is 12:26 AM.

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

About Us

"It's about Microsoft Excel"