| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF MID formula
A B
1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with an "h" (the numbers in column A will always be different but the first two letters will always be either "a", "av", or "h") Can somebody help me out on a formula please? |
Threaded Mode
