Looking for formula to extract texts from cell. See sample file. Thanks
Example:
HTML Code:
Looking for formula to extract texts from cell. See sample file. Thanks
Example:
HTML Code:
Last edited by bjnockle; 02-29-2020 at 02:14 PM.
Formula for B2: =LEFT(RIGHT(A2,LEN(A2)-FIND("|",SUBSTITUTE(A2,"-","|",2))-1),FIND("-",RIGHT(A2,LEN(A2)-FIND("|",SUBSTITUTE(A2,"-","|",2))-1))-2)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Slightly shorter version...
=MID(LEFT(A2,LEN(A2)-7),FIND("@",SUBSTITUTE(A2,"-","@",2))+2,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford. Long time No See. Thanks for the lesson.
Last edited by mehmetcik; 02-29-2020 at 04:20 PM.
mehmetcik: Outstanding solution. Works like a charm. Thanks.
FDibbins: Excellent solution. Works like a charm. Thanks.
@ mehmetcik hi there, and thanks
@bjnockle happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks