Prev: Calculate difference between current date & prior
Next: 120= rupees one hundred twenty only
From: chriswyn on 24 May 2010 11:06
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: Steve Dunn on 24 May 2010 11:24
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" <chriswyn(a)discussions.microsoft.com> wrote in message
news:833D3542-E792-435C-8824-6A0FBC7526BA(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Calculate difference between current date & prior
Next: 120= rupees one hundred twenty only