If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|