NASCAR spreadsheet question

  • Thread starter Thread starter RyneFan
  • Start date Start date
R

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.
 
Here is a formula. You could do essentially the same with a for/each macro

=LEFT(F9,FIND("/",F9)-1)
 
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.
 
Back
Top