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

  • Thread starter Thread starter max lob
  • Start date Start date
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.
 
Back
Top