I need to count the number of characters in a text string before a word. For example, lets say the word is "Apple". and the text string is "I plucked an apple from that beautiful tree". In this case the number of characters is 13.
I was thinking on the lines of something like=Len(LEFTOF("Apple)))
Thank you!
Nicole
I was thinking on the lines of something like=Len(LEFTOF("Apple)))
Thank you!
Nicole