The ISIN-codes of American companies consist of:
- US – indicating the country
- 9-digit Cusip-code
- a check digit
So if you have the ISIN-code: delete US (in excel you can use the function =RIGHT(x;10) & the check digit (in excel you can use the function =LEFT(x;9). If you need the 8-digit cusip-code, you need to use =LEFT(x,8).
When you have identifiers like SEDOL-codes, DS-codes or EntityKeys, easily to change into ISIN-codes, you also have the CUSIP-codes for CompuStat North America or Eventus.