Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula only showing positive results | Excel Discussion (Misc queries) | |||
Showing "0.00" for formula results | Excel Discussion (Misc queries) | |||
Showing negative values for formula results in red | Excel Discussion (Misc queries) | |||
Showing Cummulative Top5 results with an array-formula...? | Excel Worksheet Functions | |||
showing multiple results to a formula | Excel Worksheet Functions |