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

Martin,

Thank you for sharing the secrets of get.cell
Additional info can be found at the URL in the the following post by Tony Valko.

Lewis

You can download the macro function help files here:

http://support.microsoft.com/kb/128185

EDIT: I see a link in the MrExcel post but it has a different URL. Both go to the same address.

Originally Posted by Tony Valko

You can download the macro function help files here:

http://support.microsoft.com/kb/128185

Additional info...

The download will install 3 files:

Macrofun.cnt
Macrofun.GID
Macrofun.hlp

If you're using Windows Vista or later then you'll have to also download and install an update that allows you to view help files in their new format.

The update is available here:

http://support.microsoft.com/kb/917607

Once you have the files you need just double click the Macrofun.hlp file and you're good to go!

Of note, if you use the macro functions in your Excel file you have to save the file as a macro enabled file in the *.xlsm format if you're using Excel 2007 or later.

GET.CELL is only one of several XL4 macro functions that are still very useful. Thanks Tony Valko for posting a link to XL4 macros functions documentation.

However, because the documentation there is an .exe file, it's not accessible to Excel for Mac users. Those users (and all others) can access a complete XL4 macro function reference in the form of Word files: see my post at http://www.excelforum.com/showthread...t=#post4562316 to download...