| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I insert a space before the last character in a range of cells
Sub Addspace()
Dim cell as Range for each cell in selection if not cell.hasformula then _ cell.value = left(cell.value,len(cell.value)-1) & " " & Right(Cell.Value,1) Next End Sub -- Regards, Tom Ogilvy "Jeff" wrote in message ... Any help greatly appreciated! Jeff MCP 70-215 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count one character in a string across a range of cells? | Excel Worksheet Functions | |||
| Insert a keyboard Character e.g (/)in multiple cells of a workshee | Excel Worksheet Functions | |||
| Merge contents of cells and insert line space | Excel Worksheet Functions | |||
| Character Count Range of Cells | Excel Discussion (Misc queries) | |||
| Character Count Range of Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
