| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert space in cells
Hi
Simple one, I think, but I can't figure it out. I want to put a space in front of the contents of each cell (ie each cell that's got something in it) in a particular worksheet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
insert space in cells
=" " & cellref in a helper cell
In place................. Sub add_space() For Each cell In Selection cell.Value = " " & cell.Value Next End Sub Gord On Fri, 8 Jun 2012 18:45:01 -0700 (PDT), robzrob wrote: Hi Simple one, I think, but I can't figure it out. I want to put a space in front of the contents of each cell (ie each cell that's got something in it) in a particular worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a space in all blank cells of the first column | Excel Programming | |||
| Merge contents of cells and insert line space | Excel Worksheet Functions | |||
| Insert Space | Excel Discussion (Misc queries) | |||
| Insert Tab Space | Excel Programming | |||
| How can I insert a space before the last character in a range of cells | Excel Programming | |||
Hybrid Mode
