Hi,

We need some sample strings to extract the numbers from. The solution can be
very different depending on how the numbers and text are mixed up.

Mike

"don wonnell" wrote:

Have Excel 2002, want to remove text from cells and leave the numerical data
in those cells intact. Don't see a method for this in worksheet functions
listed by category / text & data.
--
labor market analyst, NW Ohio