Hi trankim,
Welcome to ExcelFox !
Is it 3rd or 4th ?
If your data in A1, in B1
=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))>=4,LEFT(A1,FIND("|",SUBSTITUTE(A1,"_","|",4))-1),"Text/Logo")
If it's 3, replace the highlighted 4 with 3
HTH
Hi trankim,
Welcome to ExcelFox !
Is it 3rd or 4th ?
If your data in A1, in B1
=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))>=4,LEFT(A1,FIND("|",SUBSTITUTE(A1,"_","|",4))-1),"Text/Logo")
If it's 3, replace the highlighted 4 with 3
HTH
Last edited by Admin; 05-11-2012 at 01:40 PM.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Cross-posted thread on the MrExcel forum...
MrExcel Message Board - View Single Post - Trim Text after 3rd Underscore but retain format
Yes, Rick gave me the solution to this problem on MrExcel....thank you so much!
Posting Permissions
Reply With Quote
Bookmarks