ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Search formula showing results plus 100 characters (https://www.excelbanter.com/excel-discussion-misc-queries/252734-search-formula-showing-results-plus-100-characters.html)

Deb

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)

Bob Umlas[_3_]

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)



JLatham

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)



All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com