There are several techniques that might be helpful....but, we need to know
what you're dealing with.

Are the numbers at the beginning, end, or middle of the string?
Might there be no numbers in some strings?
Are the numbers always in the same location of the string (eg 4th character
from the left)?
Is there a delimiter we can use? (slash( / ), colon (:), word ("Amount: "),
etc)

You get the idea.

***********
Regards,
Ron

XL2002, WinXP


"Chantall" wrote:

How do I seperate text and values from within the same cell?