| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text within cell then display text to left
In cell E2 I have the following:
St Louis Cardinals vs Pittsburgh Pirates for Game In cell E10 I have the following: Chicago Cubs vs Los Angeles Dodgers for Game I would like a formula in cell K2 to do the following: Find the vs in cell E2 and then display all the text to the left of it (St Louis Cardinals in this case). I included the cell E10 info so you can see that the text to the left of the vs is not the same number of characters so I can't just use the left formula. Any ideas? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Text with With Certain Criteria | Excel Worksheet Functions | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Find LARGE, and th cell 3 cells to the left? | Excel Worksheet Functions | |||
| Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Threaded Mode
