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

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