Extract all characters from the nth number of a string
Hi. The below formula in C2 is returning an error.
=B2-LEFT(B2,Search("f",B2))
I would want the formula to return all the data in B2 except all of the characters before the first occurrence of "of" from the left, "of" included. Like, "number of circles in the picture of the garden." The formula should return " circles in the picture of the garden."
Finally, I got it right by:
=RIGHT(B2,LEN(B2)-SEARCH("f",B2))
Sorry for the bother.
Thank you.
|