Hi
do you only have one occurence of strings in your cell? If yes you may try
the following array formula (entered with CTRL+SHIFT+ENTER:
=--MID(A1,MIN(IF(ISNUMBER(-MID(A1,seq,1)),seq)),LOOKUP(2,1/ISNUMBER(-MID(A1,seq,1)),seq)-MIN(IF(ISNUMBER(-MID(A1,seq,1)),seq))+1)

where seq is a defined name with the formula:
seq: =ROW(INDIRECT("1:1024"))

"blackbeemer" wrote:

How do you extract numbers or dates from a string of characters in a cell?
I have a string of characters. My dog has 3330 fleas. I want to place the
number in its own cell.