Thread: Search formula showing results plus 100 characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
  
Posts: 320
Default Search formula showing results plus 100 characters
=LEFT(G6&H6,SEARCH(C2,C6&H6)-1)

"Deb" wrote in message
...
I use a formula to find text in a particular text and ask the results plus
the next 100 characters to display in another cell. I was wondering if
there
was a way to show the proceeding characters. The formula i am using is:

=MID($G6&$H6,SEARCH(C$2,$G6&$H6),100)

Reply With QuoteReply With Quote