0

I am currently trying to get the numbers after "FCC ID:" for each cell.

Example Cell:

Brand New Aftermarket Replacement For:
FCC ID: MYT8Z0837231
IC: 4427A-8Z0837231
Chip: MEGAMOS 48 CRYPT
Frequency: 315 MHz
Reusable: Yes 
Battery: CR2032

For the multiple cells that I have sadly the "FCC ID" is either lowercase or uppercase.

I have tried the function: =RIGHT(B2,LEN(B2)-SEARCH(":", B2)) But that only works for characters.

Scott Craner
  • 148,073
  • 10
  • 49
  • 81
Shadner Joseph
  • 1
  • 1
    Investigate the VBA Split method. – freeflow Apr 06 '22 at 18:47
  • In your example MYT8Z0837231 has an 8 between the T and Z do you want all numbers or only the numbers after the last letter? You might check this answer about regex https://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops – datatoo Apr 06 '22 at 20:03

0 Answers0