| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting unwanted lead spaces throughout a worksheet
EUREKA!
David, thanks a bunch. That worked! "David Biddulph" wrote: You can do Edit/ Replace/ Alt0160/ [nothing]/ Close Or =--SUBSTITUTE(A1,CHAR(160),"") -- David Biddulph "Coles2020" <Onward2000 wrote in message ... David Thank you. The result was that those spaces are "non-breaking". Any idea on how to get rid of those? "David Biddulph" wrote: =code(LEFT(A1)) will give you the ASCII code for the first character of the string. 32 for a space. 160 for a non-breaking space. -- David Biddulph "Coles2020" <Onward2000 wrote in message ... JW I did this but was told there was nothing to replace. Does that mean that the spaces before my "1"s are something else (i.e., tabs, etc.)? "JW" wrote: Highlight the column, rows, or all cells and select Edit--Replace. In the find what field, enter a space. In the replace with field, enter nothing. If more options are not available, click the Options button. Make sure Match entire cell contents in not checked. Click Replace All. This will get rid of ALL spaces in the selected cells. Coles2020 wrote: I have FrontPage email me the result of a survey form -- with both the question and the response. If the person selects a particular question the result is "1". However, when I copy and paste the emailed results into Excel the "1" is preceded by several spaces so that I cannot perform any calculations. Is there an easy way to remove those leading spaces from all cells (both rows and columns) in my worksheets? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted spaces | Excel Worksheet Functions | |||
| Deleting unwanted data | Excel Discussion (Misc queries) | |||
| Deleting unwanted colums on a worksheet | Excel Worksheet Functions | |||
| Deleting Lead Zeros | Excel Worksheet Functions | |||
| Deleting unwanted Cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
