Home |
Search |
Today's Posts |
#7
![]() |
|||
|
|||
![]()
Hi!
If the "LL" will always be in uppercase as in your example, you can make the formula a little shorter: =SUBSTITUTE(SUBSTITUTE(A1,"LL",""),RIGHT(A1,2),"00 ")*1 Biff "CKL" wrote in message ... 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: | | =SUBSTITUTE(SUBSTITUTE(UPPER(A1),"LL",""),RIGHT(A1 ,2),"00")*1 | | Biff | | "CKL" wrote in message | ... | 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 | | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |