Dear All

I ned a amcro that will select a column and select the data which will start from 150 and change the 150 to "sg"and then delete the last 3 character of the same cells. Kindly help

For eg
from the below listed cells i need to select the cells which starts from 150 has to be changes as below

1508696901 --------------> has to change as SG8696
1508696902
asdasd -------------->this should not change
1508696903
1508696904
asdasdas
1508696905
1508696906
asdasdasd
asdasdasd
1508696908
1508696909
1508696910
1508696911

Kindly help