I am new to setting up Excel to fill out columns for me and need some =
help, please? Not even sure if I need a macro or what.
I have a column of data in the format(s)
#LL#### or
##LL####.

I need to pick up the first number(s), eliminate the Letters, then pick =
up the next 2 #'s, then change the last 2#'s to 0's (in a new column).

Can anyone please give me some help on where I start or what I need to =
do?

TIA
CKL