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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Converting a number into a cell reference 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Excel help needed: Skipping cell without skipping cell reference 1
Insert Index into a Table 1
How do I have a cell value define a dynamic named range? 15

Top