formula

[Pass-the-Reality]

I have a cell (A1) that contains data such as "Benefit Summary
307008SBVAS09" in cell B1, I want to only show the last 13 characters of
cell A1's data (307008SBVAS09). What formula would I need to add to B1?

 

[JoeU2004]

I have a cell (A1) that contains data such as "Benefit Summary
307008SBVAS09" in cell B1, I want to only show the last 13 characters of
cell A1's data (307008SBVAS09). What formula would I need to add to B1?

If it truly is always that last 13 characters, then:

=right(A1,13)