formula to extract data to left of words in cell

excel 2010:

I have Column O

I this column I have cells that have the word  "best buy"

"STEREO HEADSET BEST BUY #22323
"SOFTWARE BEST BUY #44345"

i NEED TO EXTRACT ANYTHING TO THE RIGHT OF THE WORD "BEST BUY" please


Thanks
fordtaiders
LVL 3
FordraidersAsked:
Who is Participating?
 
Shanan212Commented:
=MID(A1,FIND("BEST BUY",A1,1)+9,6)

If you only want the 6 chars after the word, then use above. If you want more chars, change the bold number as you wish
0
 
Shanan212Commented:
=MID(O1,FIND("BEST BUY",O1,1)+8,LEN(O1))

Considering you start from O1 (this would have a space infront since after BEST BUY is a space)

Alternatively,

If you wnat everything after BEST BUY(SPACE)

=MID(O1,FIND("BEST BUY",O1,1)+9,LEN(O1))
0
 
FordraidersAuthor Commented:
shanan,
Only give me 6 characters after the word best buy...instaed of everything to the right ?
if possible...

Thanks
fordraiders
0
 
nutschCommented:
Can you give the example of the text for which you only get 6 characters? Shanan212's formula should work no matter what.

Thomas
0
 
FordraidersAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.