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