Extract a number from a cell of text

  • Thread starter Thread starter pnoel
  • Start date Start date
P

pnoel

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
 
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))
 
Back
Top