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.




*** Sent via Developersdex http://www.developersdex.com ***
 

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

Copy Array to Array, how to and should I? 13
SELECT PART OF A TEXT IN A CELL 1
How to filter the QueryTable from a Web query 2
web query : part of a table not captured 11
Auto Copy Data from one worksheet to another 1
copy a hyperlink to another cell 1
Trying to create a list of prices from a web page 1
Copy Dependent On Cell Value 1

Top