Hi I have acolumn and i need to remove the first charatcter of each cell in
this column. is there an easy way to to do this please?

A

for each c in range("a2:a22")
c.value=right(c,len(c)-1)
next c

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alexey" wrote in message
...
Hi I have acolumn and i need to remove the first charatcter of each cell
in this column. is there an easy way to to do this please?

A

Thanks
A

"Don Guillett" wrote in message
...
for each c in range("a2:a22")
c.value=right(c,len(c)-1)
next c

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alexey" wrote in message
...
Hi I have acolumn and i need to remove the first charatcter of each cell
in this column. is there an easy way to to do this please?

A