Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 18th October 2016, 05:09 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default Excel help

Just after some help with excel, have a problem where it wont recognise numbers from copied/pasted data.

I am trying to copy the race results table from racing and sports results in to excel to run some basic calcs on.

Race 1 for example http://www.racingandsports.com.au/e.../15-10-2016/all


However the dividends under the NSW/VIC/UNI/BF it wont recognise and allow me to add them up at the bottom, or perform any calcs on. The prices in the SP column work fine though.

Any one come across this before? Have tried a google search, but the simple solutions found there dont seem to help at all.
Reply With Quote
  #2  
Old 18th October 2016, 08:18 PM
walkermac walkermac is offline
Member
 
Join Date: Nov 2013
Posts: 596
Default

The data is pasted as text, instead of a number. You'll have to convert it before you can perform arithmetic operations.

If the data you want is in column K you could, for example, post this formula in cell Q1 and then fill it down the page:

Code:
=IFERROR(VALUE(RIGHT(K1,LEN(K1)-1)),"")
Reply With Quote
  #3  
Old 20th October 2016, 01:09 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Simplest way i have found is just to add zero like this, if your text was in cell AI in cell B1 you would have 0+A1 the Zero can also be added to any other formula you may have.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #4  
Old 20th October 2016, 04:27 PM
ballybeg ballybeg is offline
Member
 
Join Date: Jun 2012
Posts: 12
Default Excel help

Simple...copy the table you need from R&S. Pasting by using the Edit menu or simple Ctrl+V pastes it as HTML. Instead you need to paste it as text.

Switch to Excel...right click on the worksheet, click on Paste Special, select the Text option.

ballybeg

Last edited by ballybeg : 20th October 2016 at 04:29 PM.
Reply With Quote
  #5  
Old 20th October 2016, 06:42 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default

Thanks for the suggestions and tips.

Ballybeg, perfect, that works nice and easy!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 11:39 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655