CONCATENATE part of cell

[Legacy 185509]

Hi
I have this text in cell B2
A0_13_FDF812_FDMW Number 812 can change for cells below it

I only want to get text 812 this three digit text from this cell.
please help

below is formula I am trying, it is not working

=CONCATENATE("'",RIGHT(B2,FIND("_FDF",B2,1)-1),"")

 

[Rick Rothstein]

I have this text in cell B2
A0_13_FDF812_FDMW Number 812 can change for cells below it

I only want to get text 812 this three digit text from this cell.
please help[/CODE]

You did not tell us anything about the "shape" of your text. Is there always the same number of characters before the number you want (that is, the A0_13_FDF part is 9 characters long... are there alway 9 characters in front of the 3-digit number)? If so, try this formula...

=MID(B2,10,3)

If not, are there always 5 digits after the 3-digit number? If so, then try this formula...

=MID(B2,LEN(B2)-5,3)

If neither of the above, then what part of the text is "fixed"... always 2 underlines followed by letters in front of the number you want? or perhaps always an underline character immediately after the number? something else?

 

[Legacy 185509]

Hey yes, it is same sho
thanks alot
that worked

 

[ukmikeb]

@Rick

Shouldn't your second formula be -

=MID(B2,LEN(B2)-7,3)

 

[Rick Rothstein]

.
zit1343 take note....

@Rick

Shouldn't your second formula be -

=MID(B2,LEN(B2)-7,3)

He-he.... yep, it sure should be. It looks like I counted backwards to the first digit from the back instead of the last digit from the back. Thanks for catching that.