| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers followed by space
Select the range to fix
Edit|replace what: ALT+0160 with: (leave blank) replace all Note: While Enter 0160 in find what Hold the ALT KEY "malewis48" wrote: I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Allow numbers, comma, - and space | Excel Discussion (Misc queries) | |||
| How can I remove a space between a letters and set of numbers? | Excel Discussion (Misc queries) | |||
| How do I write a script to add space between numbers in a column? | Excel Discussion (Misc queries) | |||
| Extra space after imported numbers | Excel Discussion (Misc queries) | |||
| Space between decimal numbers | Excel Worksheet Functions | |||
Threaded Mode
