Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello
Why does not Excel 2003 Replace command remove spaces from cell contents? Is there any other way than the trim function to remove spaces after numbers in cells? |
#2
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Replace should remove spaces - highlight your cells then CTRL-H. In the
"Find What" panel enter a single space, in the "Replace With" panel leave this empty, then click Replace All and your spaces should have gone. If you have spaces after a number in a cell (and therefore the cell contains text), you can convert it to a number in another cell by means of: =VALUE(A1) and copy this down if necessary. Hope this helps. Pete |
#3
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Thu, 6 Apr 2006 16:15:28 +0400, "Dmitry" wrote:
Hello Why does not Excel 2003 Replace command remove spaces from cell contents? Is there any other way than the trim function to remove spaces after numbers in cells? I'll guess from the incomplete information you've posted, that you've imported your numbers from an HTML source (i.e. the web) and what you think is a <space is really a <non-break-space That being the case, in the Find box of the Replace command, try entering the nbsp code -- hold down <alt and, from the numeric keypad, type 0160; then release the <alt button. Leave the Replace box blank. --ron |
#4
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks Pete!
The Replace does not remove a space after a number in a cell. The cells are in the text format. "Pete_UK" ???????/???????? ? ???????? ?????????: oups.com... Replace should remove spaces - highlight your cells then CTRL-H. In the "Find What" panel enter a single space, in the "Replace With" panel leave this empty, then click Replace All and your spaces should have gone. If you have spaces after a number in a cell (and therefore the cell contains text), you can convert it to a number in another cell by means of: =VALUE(A1) and copy this down if necessary. Hope this helps. Pete |
#5
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yes, I've imported my numbers from the web. Thank you Ron Rosenfeld very
much! "Ron Rosenfeld" ???????/???????? ? ???????? ?????????: ... On Thu, 6 Apr 2006 16:15:28 +0400, "Dmitry" wrote: Hello Why does not Excel 2003 Replace command remove spaces from cell contents? Is there any other way than the trim function to remove spaces after numbers in cells? I'll guess from the incomplete information you've posted, that you've imported your numbers from an HTML source (i.e. the web) and what you think is a <space is really a <non-break-space That being the case, in the Find box of the Replace command, try entering the nbsp code -- hold down <alt and, from the numeric keypad, type 0160; then release the <alt button. Leave the Replace box blank. --ron |
#6
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Thu, 6 Apr 2006 17:07:08 +0400, "Dmitry" wrote:
Yes, I've imported my numbers from the web. Thank you Ron Rosenfeld very much! "Ron Rosenfeld" ???????/???????? ? ???????? ?????????: ... Glad to help. Thanks for the feedback. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create different hyperlinks within one cell in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 cell contents truncated when linked into Word? | Links and Linking in Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
hide cell contents and make it reappear (Excel) | Excel Discussion (Misc queries) | |||
Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) |