Extract all characters from the nth number of a string

Marcia · #1 02-24-2020, 02:13 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract States from a String	soldat452002	Excel	9	04-26-2018 04:16 AM
Extract a string from a paragraph	kirkm	Word VBA	7	09-11-2016 06:13 PM
How to extract only numbers from a STRING?	Learner7	Excel	3	07-02-2013 06:25 AM
Extract Numbers from Alphanumeric String	OTPM	Excel	6	05-13-2011 12:52 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM