Excel – Return all characters but the first X amount Excel 2007

excelexcel-formula

I've got a long list of codes and text in the same cell. I need to return all the text from the right BUT the first five characters

ex. V2341 something here

I need to return the something here

=RIGHT(LEN(A1)-5)

That's what I've tried, but no luck with it. I know it's gotta be close to correct, what am I missing?

Thanks.

Best Answer

You're looking for MID.

If column A contains

    A                          C                         D
    ====================       ======================    ==============
1   ABCDE12345                 D1=MID(A1, 6, LEN(A1))    12345
2   ABCDE1234567890ABCD        D2=MID(A2, 6, LEN(A2))    1234567890ABCD
Related Topic