View Single Post
  #2   Report Post  
Old January 7th 10, 10:38 PM posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 320
Default Search formula showing results plus 100 characters

=LEFT(G6&H6,SEARCH(C2,C6&H6)-1)

"Deb" wrote in message
news
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)