Eliminate all but last 8 characters in a cell for an entire column of cells.

[Bobaree6]

Can anyone show me how to eliminate all but the last 8 digits in a cell? I need to do this for a column of cells down to the first empty cell. For example, I need to leave the last 8 digits in this string of text and numbers:

AAPL210319C00105000

 

[alansidman]

Assume your data in Column A. In Column B, type =Right(A1,8) and then copy down.

 

[Bobaree6]

Assume your data in Column A. In Column B, type =Right(A1,8) and then copy down.

Thank you, Sir.