removing first character in cell

[Alexey]

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

 

[Don Guillett]

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

 

[Alexey]

Thanks
A

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]