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
|