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
|
|||
|
|||
Extract a number from a cell of text
I am trying to find out what formula I would use to
extract the number from the following cell: Numer of items in truck,13625. Then place the number in another cell where it can be used in another formula. Thanks Pnoel |
#2
|
|||
|
|||
Extract a number from a cell of text
will this work. where f2 has your example.
We are finding the "," and subtracting that from the length of the text and getting that number to the right. =RIGHT(F2,LEN(F2)-FIND(",",F2,1)) "pnoel" wrote in message ... I am trying to find out what formula I would use to extract the number from the following cell: Numer of items in truck,13625. Then place the number in another cell where it can be used in another formula. Thanks Pnoel |
#3
|
|||
|
|||
Extract a number from a cell of text
Hi,
Assuming that truck,13625 is in cel A1, type the following formula in cell B1 - IF(MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$8),1)),0) 1,1*MID (A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW ($1:$8),1)),0),255),1*MID(A1,MATCH(TRUE,ISNUMBER(1 *MID (A1,ROW($1:$8),1)),0),SUM(COUNT(1*MID(A1,ROW($1:$1 9),1))))) This formula should be array entered (Do this by Pressing Ctrl+Shift+Enter after you have copied/typed the above formula in cell B1). Regards, Ashish Mathur Excel - MVP -----Original Message----- I am trying to find out what formula I would use to extract the number from the following cell: Numer of items in truck,13625. Then place the number in another cell where it can be used in another formula. Thanks Pnoel . |
Thread Tools | |
Display Modes | |
|
|