How to use EXCEL Formula properly =RIGHT(A2,13)

Question

How to use EXCEL Formula properly =RIGHT(A2,13)

ayen2936 0

I have hundreds of lines that looks like below in one column, and I am trying to retain just this part "LM202504170121" in that column. How can I ungroup the column or use =RIGHT() formula to do that? Thank you

'07/2025 LM REJECTED 192X 1 LM202504170121 11 GS0726E

1 answer

Your answer

Answer 1

Depending on what version of excel you are using you can leverage a smarter formula.

=INDEX(TEXTSPLIT([CellReference]," "),6)

This breaks the word down like a CSV, but using a space (" ") to separate them. You then just index the "column" you need.

TEXTSPLIT is a fairly new formula however.

Older versions I would advice to have some helper columns to break it down. Keep doing this until you get to the column you need
=RIGHT(A1,LEN(A1)-LEN(LEFT(A1,FIND(" ",A1,1))))

This is a lot, what we are effectively trying to do is find the space, and chop off the word on the left. This is because find goes from left to right.

On the first pass, this gives back
LM REJECTED 192X 1 LM202504170121 11 GS0726E

Can see it's chopping off the left. Do this a few more times till your item. Then use
=LEFT(F1,FIND(" ",F1,1))

ayen2936 0 Reputation points

2025-05-01T17:44:33.77+00:00

I figured it out. I higlighted the column, clicked data, text to columns, delimited, next, click space, next then finish, hit ok. Thank you!

Share via

How to use EXCEL Formula properly =RIGHT(A2,13)

1 answer

Your answer