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

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 ***

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

hi
a formula might do it
in G6 enter....
=LEFT(F6,FIND("/",F6,1)-1)

regards
FSt1

"max lob" wrote:



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 ***