#1
|
||||
|
||||
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. |
#2
|
|||
|
|||
Hi Marcia,
It's no problem to post if you are hitting a snag. Glad you found your solution, but here is another one you could try. =MID(B2,SEARCH("of",B2)+2,LEN(B2)) |
#3
|
||||
|
||||
Thank you Jeffrey. I prefer your formula. It is confusing to use the RIGHT function.
|
|
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 |