Remember Me?

#1
January 7th 10, 09:28 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 102
Search formula showing results plus 100 characters

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)

#2
January 7th 10, 09:38 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2009 Posts: 320
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)

#3
January 7th 10, 09:51 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 2,204
Search formula showing results plus 100 characters

Assuming that the formula you have shown is in cell D2, then a formula like
this would do the trick:
=IF(LEN(D2)0,LEFT(G\$6&H\$6,LEN(G\$6&H\$6)-LEN(D2)),"")

However, if D2 (your formula) comes up with an error because the contents of
C\$2 isn't found in G\$6 & H\$6, then the formula above will display the same
error.

"Deb" wrote:

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)

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Davidm Excel Discussion (Misc queries) 2 August 19th 08 05:17 AM kate_suzanne Excel Discussion (Misc queries) 4 April 25th 08 07:49 PM sherden_hershey Excel Discussion (Misc queries) 5 February 15th 08 12:50 AM Jen[_4_] Excel Worksheet Functions 15 July 2nd 07 04:54 PM Robert Brown Excel Worksheet Functions 4 July 19th 06 09:52 PM

All times are GMT +1. The time now is 05:19 AM.