I want to return the 7 letters of text that appears after the word Timer in cell A1. So cell A1 will be a sentence with the word Timer in it somewhere and I want to return the 7 characters after it appears.
I want to return the 7 letters of text that appears after the word Timer in cell A1. So cell A1 will be a sentence with the word Timer in it somewhere and I want to return the 7 characters after it appears.
Last edited by ScabbyDog; 04-11-2013 at 07:04 AM.
I should also add that after the word timer and the 7 characters there will be more text.
"I want to return the 7 letters"
"I want to return the 9 characters"
7 letters after or 9 letters after, which is it?
I'll assume 7
=MID(A1,SEARCH("Timer",A1)+5,7)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks