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

C

chriswyn

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.
 
S

Steve Dunn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace numeric strings in larger text strings 8
Searching the formula (not the value) for a text string 1
removing text characters from a cell 12
Extracting just the time portion 5
text to column 1
Cells only display a maximum number of text characters 4
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Reference text in a cell inside a formula to specify a sheet name 4

Top