Separate Number Suffix?

you can use get.cell and old excel 4 macro function
select B2
then insert name /define
create a name say "mycell"
in refers to put =GET.CELL(53,Sheet1!$A2)
so
=mycell in b2 would then return the contents of a2 as text including the custom format
then you can use in b2 formulas like
=IF(RIGHT(mycell,3)="pac",A2*3,A2)
note it needs to be saved as xlsm a macro enabled workbook