| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removal of 100's of spacing in numbers
I want to be able to use the replace command, but it wont find the spaces
for me. When I copy tables with numbers from various sources, I get spaces inside and after the numbers. E.g. 1 234 I know the use of SUBSTITUTE and other functions, but it is not an effective way of working when there are so many columns. I have tried to change the cell format to text, but still no luck in finding the spaces with the replace command. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Revome blank spacing from ending Numbers | Excel Worksheet Functions | |||
| Removal of text from a cell containing both text and numbers | Excel Discussion (Misc queries) | |||
| deleting 100's of pictures, keep data | Excel Worksheet Functions | |||
| Still no joy - trying to view 100's of file TITLES | Excel Discussion (Misc queries) | |||
| Formatting 100's and 1000's | Excel Discussion (Misc queries) | |||
Threaded Mode
