Display text from right side of character when there us two the same.

[daza34]

Hi,

I have a cell full of text but also numbers and under scores.

645_OCC Collaborate_3

I have written the below but it displays the text after the first _ and i need it to show the text/number after the last _

=MID(K2:K38272,FIND("_",K2:K38272),200)

I hope this is possible and any help would be appreciated

 

[daza34]

Sorry also there is also a different word on another cell but same requirements needed

_OCC VOICE_3

 

[Phuoc]

Try this:

=TRIM(RIGHT(SUBSTITUTE(K2:K38272,"_",REPT(" ",200),200)))

 

[daza34]

Thank you but i have numerical that go above 9 (IE 10 etc)

Sorry it must have been the way i described it.

 

[Sergius]

Try this:

=MID(K2;FIND("_";K2;FIND("_";K2)+1)+1;500)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[daza34]

Version 2208 Build 16.0.15601.20590) 64-bit

 

[Fluff]

Is that 365, 2021 or some other version?

 

[daza34]

365

 

[Fluff]

Thanks, please remember to update your profile. It save people having to ask.

How about

=textafter(K2,"_",-1)