About Usage of FIND&LEN&RIGHT

[Willingtolearnsmthng]

Hi again,
As I showed in the image, I have to find 2 numbers right of "L". I have tried this formula,

=RIGHT(Data1!J2,2)

but I cannot apply other cells. What should I do?
I will be waiting for your advice.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: About Usage of FIND&LEN&RIGHT
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Willingtolearnsmthng]

I got it, I didn't know.
Thanks to warn me.

 

[6StringJazzer]

Seems to be a duplicate post except in the other thread you were asking about H.

To get the two digits to the left of L use the exact same formula but change "H" to "L"

 

[Fluff]

Is the only difference between this thread & you other one just the change in letter?

 

[Willingtolearnsmthng]

Seems like that, but not. There is some difference. When I used the same formula for L, it didn't work. But I solved this problem. I converted the number from text with paste special and I used RIGHT and LEN functions.