| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete space in Text
How about selecting C11:C2000 and then
edit|Replace what: (spacebar) with: (leave blank) replace all If you need it as a macro, you can record it when you do it manually. herve wrote: Hello, does anyone know a macro that could remove the blanks or Space in cell C11 to C2000 (where there is text) Ex. 20 15 10 Thanks in advance. -- herve ------------------------------------------------------------------------ herve's Profile: http://www.excelforum.com/member.php...o&userid=27314 View this thread: http://www.excelforum.com/showthread...hreadid=473046 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete space after word | Excel Discussion (Misc queries) | |||
| How do I delete a space at the end of an amount or text | Excel Worksheet Functions | |||
| Delete space | Excel Discussion (Misc queries) | |||
| Is there a way to use the space bar to delete? | Excel Worksheet Functions | |||
| Is there a way to use the space bar to delete? | Excel Worksheet Functions | |||
Threaded Mode
