Excel query regarding PAN no

This discussion seeks an Excel formula to determine if a PAN number indicates a 'Company' or 'Non-Company'. The user wants to check the fourth letter of the PAN; if it's 'C', it should be classified as 'Company', otherwise 'Non-Company'. While a formula was suggested, it wasn't working as expected, and the user noted the PAN format is confidential for internal departmental use only, with specific constraints on which letters can be revealed.