Reference a cell with text and numbers

C

Chort

I've got a table that querys another table online. The table online has cells that contain both text and numbers, thus my worksheet does as well. Is it possible to make references to Just the numbers in the cells in my worksheet, without messing up the internet query?
 
F

Frank Kabel

Hi
you may provide some more details. e.g. post some example rows of your
data (plain text - no attachment please) and show your expected result
 
Top