Hi!
I want to extract 2 words after is in the folowing string:
My name is John Bon and I don`t want to stay - return John Bon
I want to extract every characters before "is" (include is) in the following string
My name is John Bon and I don`t want to stay - My name is
In some of my rows there is no "is", and I don`t want the crazy symbol, so I need to use "iserror"
Can you help?
Hi try this formula for first case
right(A1,len(A1)-find("is",A1,1)-2)
for the rest better send the sample with expect results
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Her is a sample file
Hi look into attachment formula is huge but works (maybe someone else can create simpler one)
In B2,
C2,
Please Login or Register to view this content.
then copy down.Please Login or Register to view this content.
Last edited by Haseeb Avarakkan; 04-12-2012 at 04:12 AM. Reason: Replace IFERROR in 2nd formula
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks