| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Revome blank spacing from ending Numbers
Select ur Range
Press CTRL+H Find What: ALT+0160 Replace With: Blank OK NOTE: While Entering the 0160 Hold the ALT Key "Calculate Date range" wrote: need your urgent help I have a list a numbers as followings with extra bank spacing at the end of the numbers, please advice me how to set a formula to remove it 40,900.18 1,064.65 3,453.47 6,976.03 3,186.34 6,642.70 6,183.19 8,371.08 3,414.53 8,202.76 3,524.61 3,837.21 3,392.37 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filtering for numbers ending in 000 | Excel Discussion (Misc queries) | |||
| Custom Filter for ending numbers | Excel Discussion (Misc queries) | |||
| How do you add three ending '0's to a column of numbers? | Excel Discussion (Misc queries) | |||
| spacing numbers in 1st column by inch intervals of 2nd column | Excel Worksheet Functions | |||
| Ending a macro early conditionally on one cell being blank | Excel Discussion (Misc queries) | |||
Threaded Mode
