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!

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.

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