route217
asked on
If formula depending on end of file path extension name
Hi Expert
How would you right an if formula with len function to say if the in Column A row 2 we have 'zzXP_01_MAD4.mde i.e. end with .mde then microsoft otherwise other software..
How would you right an if formula with len function to say if the in Column A row 2 we have 'zzXP_01_MAD4.mde i.e. end with .mde then microsoft otherwise other software..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.