D
DIDS
Hello,
I have a list of values in column C (275,372 cells) and would
like to know if there is a way to look at each cell and delete the 1st
character if the string is longer than 6 characters. Below is what
the before sample would look like.
009075
009130
0009767
010471
010489
011640
013373
013824
017424
019038
020634
020642
020663
0020711
020723
So the above list will look like this after:
009075
009130
009767
010471
010489
011640
013373
013824
017424
019038
020634
020642
020663
020711
020723
Thanks you for any help you can provide,
DIDS
I have a list of values in column C (275,372 cells) and would
like to know if there is a way to look at each cell and delete the 1st
character if the string is longer than 6 characters. Below is what
the before sample would look like.
009075
009130
0009767
010471
010489
011640
013373
013824
017424
019038
020634
020642
020663
0020711
020723
So the above list will look like this after:
009075
009130
009767
010471
010489
011640
013373
013824
017424
019038
020634
020642
020663
020711
020723
Thanks you for any help you can provide,
DIDS