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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
Ref Formula Query 1
Data Validation - Prevent delete 2
help with formula 1
copy and paste the cell with formula ="1" 3
Combining Text From Cells 3
EXCEL FORMULA 2
Conditional Concatenate? 2

Back
Top