Hi Dears,
I wanna do this process without column adding and formula. Only macro i need. Could you please help me about it?
Thank you in advance.
A column data
5555555555
555555
5555555
4444
444
444444444
333333
3333
33333333
B column formula
left(A1,3)
C column formula
lenght(A1)
D...