Thanks Biff! Although not as familiar looking...... (read - "new" to me =
<g"), it makes sense.....
I will take a look at this too - just to learn!

"Biff" wrote in message =
...
| Another way:
|=20
| =3DSUBSTITUTE(SUBSTITUTE(UPPER(A1),"LL",""),RIGHT( A1,2),"00")*1
|=20
| Biff
|=20
| "CKL" wrote in message=20
| ...
| I am new to setting up Excel to fill out columns for me and need some =
help,=20
| please? Not even sure if I need a macro or what.
| I have a column of data in the format(s)
| #LL#### or
| ##LL####.
|=20
| I need to pick up the first number(s), eliminate the Letters, then =
pick up=20
| the next 2 #'s, then change the last 2#'s to 0's (in a new column).
|=20
| Can anyone please give me some help on where I start or what I need to =
do?
|=20
| TIA
| CKL=20
|=20
|