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 |