| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Left Function Question Help!
Hi Everyone
I have this formulae in my cell; =if(left(a1,1)="A",1,if(left(a1,1)="B",2,if(left(a 1,1)="C", 3,................... and so on. Question is.. I have to put in 'left(a1,1) each time I give conditions. Is there other method of making this formulae simpler? so I don't have to type left(a1,1) = Thank you for your help in advance. Regards James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| Left vs Left$ function | Excel Discussion (Misc queries) | |||
| Question for about using IF formula LEFT function at the same time | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| Question about using the right or left formula | Excel Discussion (Misc queries) | |||
Threaded Mode
