Formula to extract text from a certain point

for the 1st 1...
=MID(A1,SEARCH("to",A1),999)

for the 2nd part
=LEFT(MID(A1,SEARCH("From",A1),99),SEARCH("call",MID(A1,SEARCH("From",A1),99))-2)

I’d use this for the second requirement:

=SUBSTITUTE(MID(A1,FIND("from",A1),99),B1,"")

Thanks for the Help Ford


If text to appears in other text for eg BR1 Auto call to BR4 call, then the first formula must extract the "to" after when the first call appears


I have highlighted the item in B1 how it should appear (your formulas are in Col D & E


Kindly amend your formula in Col D & E so that they give the sme result as my manual extract in Col B & C

Try this:

=TRIM(MID(A1,SEARCH(" to",A1),99))

See post #3 for the second option - a shorter version.

You can’t have it both ways: you seem to want to exclude auto but include fast frt - this is illogical.

I can’t see any error messages in that file.

First, you need to use the correct formula in B1. Then try this in C1:

=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("from",A1),99),B1,"")," auto","")

This is a case of creeping goalposts. Why don’t you just state clearly what you want and what you don’t want instead of hinting and then expecting us to constantly tweak?

I’m out.

That's good news.