| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Varying left criteria based on 1st Letter....If Function?
Hello,
I am using Pivot Tables for Inventory purposes. I'd like to use a shortened description based on the first letter of the description. Can I use an If Statement? Such as if 1st letter of Description is M - use 1st Left 5 characters, if 1st letter of description is L - use 1st Left 8 characters? Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Varying left criteria based on 1st Letter....If Function?
=IF(LEFT(A1)="M",LEFT(A1,5),IF(LEFT(A1)="L",LEFT(A 1,8),"If not then display
this")) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "seve" wrote in message oups.com... Hello, I am using Pivot Tables for Inventory purposes. I'd like to use a shortened description based on the first letter of the description. Can I use an If Statement? Such as if 1st letter of Description is M - use 1st Left 5 characters, if 1st letter of description is L - use 1st Left 8 characters? Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Varying left criteria based on 1st Letter....If Function?
Or perhaps more scalable:-
=LEFT(A1,VLOOKUP(LEFT(A1),{"L",8;"M",5},2,0)) which can be expanded quite easily to add more letters:- =LEFT(A1,VLOOKUP(LEFT(A1),{"A",4;"B",5;"C",6;"L",8 ;"M",5;"X",3;"Y",4;"Z",5},2,0)) Regards Ken................ "Ken Wright" wrote in message ... =IF(LEFT(A1)="M",LEFT(A1,5),IF(LEFT(A1)="L",LEFT(A 1,8),"If not then display this")) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "seve" wrote in message oups.com... Hello, I am using Pivot Tables for Inventory purposes. I'd like to use a shortened description based on the first letter of the description. Can I use an If Statement? Such as if 1st letter of Description is M - use 1st Left 5 characters, if 1st letter of description is L - use 1st Left 8 characters? Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
| How can I reference a cell as the criteria in a count if function. | Excel Discussion (Misc queries) | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
