Extract a number from a cell of text

[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

 

[Don Guillett]

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