Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default formula

"Pass-the-Reality" wrote:
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)