formula

  • Thread starter Thread starter Pass-the-Reality
  • Start date Start date
P

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?
 
Pass-the-Reality said:
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?
Click to expand...

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

=right(A1,13)
 
Back
Top