Hi All,

i am trying to crate a formula based on the below criteria (user selection), but I am hiiting the limit of 5000 characters (size) limit.

1. I have a 2 picklist fields, with one dependant. Business Unit, Product Type (dependant)
2. If a user Selects Business unit (BET) and a Product Type with an acronym (e.g BGC), an enquiry number is generated based on the Product Type with a 5 character long number appended at the end (e.g BGC-00001).
3. If no Product Type is selected for Business Unit BET, then the Enquirt Number Should be BET-00001
4. Should the Business Unit NOT be BET, the Enqury Number is the business unit appended with a 4 character long number (e.g AUS-0001

I currently have the following code, but hit the limit when saving.  Please assist (reluctant on going to code for this):

IF (
AND(
ISPICKVAL(Business_Unit__c,"Bateman Engineered Technologies (BET)"),
OR(
ISPICKVAL(Product_Type__c,"Air Environmental (BPC)"),
ISPICKVAL(Product_Type__c,"Cement (BLC)"),
ISPICKVAL(Product_Type__c,"Comminution (BUC)"),
ISPICKVAL(Product_Type__c,"Conveyors (BCC)"),
ISPICKVAL(Product_Type__c,"Distribution (BGC)"),
ISPICKVAL(Product_Type__c,"Jetfloat (BQC)"),
ISPICKVAL(Product_Type__c,"Load Out Stations (BEC)"),
ISPICKVAL(Product_Type__c,"Pneumatics (BLC)"),
ISPICKVAL(Product_Type__c,"Process Equipment (BOC)"),
ISPICKVAL(Product_Type__c,"Specialised Handling (BAC)"),
ISPICKVAL(Product_Type__c,"Stackers & Reclaimers (BBC)"),
ISPICKVAL(Product_Type__c,"Water (BMC)")
)),
LEFT(SUBSTITUTE(TEXT(Product_Type__c ),LEFT(TEXT(Product_Type__c),FIND("(",TEXT(Product_Type__c))), ""),3)&"-"&
LPAD(Enquiry_Number2__c,5,'0'),

IF(

ISPICKVAL(Business_Unit__c,"Bateman Engineered Technologies (BET)"),

LEFT(SUBSTITUTE(TEXT(Business_Unit__c),LEFT(TEXT(Business_Unit__c),FIND("(",TEXT(Business_Unit__c))),""),3)&"-"&
LPAD(Enquiry_Number2__c,5,'0'),

LEFT(SUBSTITUTE(TEXT(Business_Unit__c),LEFT(TEXT(Business_Unit__c),FIND("(",TEXT(Business_Unit__c))),""),3)&"-"&
LPAD(Enquiry_Number2__c,4,'0')
))

Thanks in advance