from the text 4 pcs., how to remove only characters/text
 

Pls help me in the above subject i.e. from the cell contents in excel as "4
Pcs.", what is the formula to be used to remove only number and mention in a
separate cell. i.e. cell should contain only numeric value, not the text.

from the text 4 pcs., how to remove only characters/text
 

Chris, is the syntax always the same? i.e. a figure followed by a space
followed by text.

=VALUE(LEFT(A1,FIND(" ",A1)))

If it isn't, it may be advisable to provide more information on the
possibilities before we get further into it.




"chriswyn" wrote in message
...
Pls help me in the above subject i.e. from the cell contents in excel as
"4
Pcs.", what is the formula to be used to remove only number and mention in
a
separate cell. i.e. cell should contain only numeric value, not the text.