Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a number in a cell
In cell B239 I have the following text
Carolina 3 at Pittsburgh 4 (SO) All of column B is like this except with different team names. I would like a formula to pull out the number 4. Any idea how to do this? I have been trying to use the right command with the find command but I can't quite get it. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to find how many cell have a number between 2 numbers. | Excel Worksheet Functions | |||
Is there a way to find out whether theres a number in a cell?? | Excel Discussion (Misc queries) | |||
Can I find the number of letters in a cell? | Excel Discussion (Misc queries) | |||
Find the 1st occurance of a number in a cell | Excel Worksheet Functions | |||
find the cell above any number in any range | Excel Worksheet Functions |