ExcelBanter - Insert Character At start of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Insert Character At start of cell (https://www.excelbanter.com/excel-programming/329522-insert-character-start-cell.html)

Andibevan[_2_]

Insert Character At start of cell

Hi All,

How do I insert the character "-" at the start of each cell in the active
selection?

Thanks

Andi

147man

Insert Character At start of cell

for each c in selection.cells
c.value="-" & c.value
next c

All times are GMT +1. The time now is 08:59 AM.