NASCAR spreadsheet question

[RyneFan]

I am using LOOKUP to bring a string of values over to a different page in a
worksheet. When I cut and paste the race results from NASCAR.COM, the points
column is in text format. It looks like this for example. 165/10, or 87/0.
How can I turn those examples into a number I can add at the top of the column?
I only need the numbers to the left of the "/". Thanks in advance for all
your help. This site has been very helpful in the past.

 

[Don Guillett]

Here is a formula. You could do essentially the same with a for/each macro

=LEFT(F9,FIND("/",F9)-1)

 

[Chris Leonard]

Use this formula in your lookup

=MID(lookup(?,?,?),1,FIND("/",lookup(?,?,?),1)-1)

 

[Ken Wright]

If you don't need to retain the other data after the /, then select the column
of data, do Data / text To Columns / Delimited / Tick Other and put / in the
box - Select the second column and choose 'Do not import this column' from the
options. Now just refer to the data normally.