How to copy a part of a cell coming from a Web Query?

M

max lob

Hi friends, I need a very specific help.

In my spreadsheet, I've imported data from an external server, which
returns the following data in column F:

F6: 45/500
F7: 12/50
F8: 222/500

Well, the thing is that I only need the first part of the content, I
mean the numbers before the "/"

Is there any way to copy only the info before "/" and copying it into
column G, for example?

I tried with "text in columns" but the update process coming from the
web query returns everything to original.

Thank you and I hope your appreciated help.

Max.
 

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

The Last of Us - Part I (PC) 6
VBA Compare part of cell to another cell and then calculate 0
web query doesnt copy the essential part. 1
SELECT PART OF A TEXT IN A CELL 1
web query : part of a table not captured 11
How to filter the QueryTable from a Web query 1
Copy to a Cell 1
Delay copy & paste of data until web query refreshes? 2

Top