| 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) |
| 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 | |||
Threaded Mode
