| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text within cell then display text to left
Hi!
Try this: =LEFT(E2,FIND(" vs ",E2)-1) Biff "Jambruins" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text within cell then display text to left
Try this:
=LEFT(E2,FIND("vs",E2,1)-2) HTH, Elkar "Jambruins" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text within cell then display text to left
Try this:
K2: =LEFT(E2,SEARCH(" vs",E2)-1) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jambruins" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text within cell then display text to left
Thanks for the help. It works perfectly!
|
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text within cell then display text to left
You're welcome. Thanks for the feedback!
If you want to extract Pittsburgh Pirates: =MID(E2,FIND(" vs ",E2)+4,FIND(" for ",E2)-(FIND(" vs ",E2)+3)) Biff "Jambruins" wrote in message ... Thanks for the help. It works perfectly! |
| Reply |
| 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) | |||
Linear Mode
