| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
