| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Disregard text in a cell
Please forgive my ignorance, I am looking to do something similar here. I am looking to divide the contents of cell B21 by the contents of cell A27 on my Excel sheet. The problem I am encountering is cell A27 contains the following "9 Waitresses" and I am looking to have the formula disregard the text "Waitresses". Can anyone tell me how to do this? Many thanks!
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disregard text in a cell
On Wed, 11 Jan 2012 22:18:56 +0000, JackLafleur wrote:
Please forgive my ignorance, I am looking to do something similar here. I am looking to divide the contents of cell B21 by the contents of cell A27 on my Excel sheet. The problem I am encountering is cell A27 contains the following "9 Waitresses" and I am looking to have the formula disregard the text "Waitresses". Can anyone tell me how to do this? Many thanks! You show a number in A27 followed by a space and then text. If that is your format, then you can use: =B21/LEFT(A27,FIND(" ",A27)-1) If your format may vary from that, you will need to be more specific. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disregard text in a cell
This isn't a solution, but a suggestion.
You'll find your excel life lots easier if you put the number in a dedicated cell/column and the words/description in a different cell/column. I'd use columns A and B. On 01/11/2012 16:18, JackLafleur wrote: Please forgive my ignorance, I am looking to do something similar here. I am looking to divide the contents of cell B21 by the contents of cell A27 on my Excel sheet. The problem I am encountering is cell A27 contains the following "9 Waitresses" and I am looking to have the formula disregard the text "Waitresses". Can anyone tell me how to do this? Many thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| disregard a cell on occasion when there is text in it instead of V | Excel Worksheet Functions | |||
| MS suggestion, disregard: Custom Format Text | Excel Discussion (Misc queries) | |||
| how to disregard the DIV in a range | Excel Worksheet Functions | |||
| Filesearch with disregard of Case | Excel Programming | |||
| Disregard last posting | Excel Programming | |||
Linear Mode
