New Posts For Thread: Excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-pleaseHi, I have a list of horse names in excel with their country code in brackets such as:Horse Name (IRE)..and would like to remove all the info after the horse name so I am just left with the horse name.Is there any code I could use to do this please?TThanks again, especially Aye Robot. Your method was very simple, cheers..https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343078#430343078Thanks again, especially Aye Robot. Your method was very simple, cheers..Wed, 28 Apr 2010 10:56:03 -0500sandcYou are making sure you don't import the "suffix" column, not the original column which would have the horse name in the case requested.The copy paste scenario is certainly nothing I have come across.https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343074#430343074sandcYou are making sure you don't import the "suffix" column, not the original column which would have the horse name in the case requested.The copy paste scenario is certainly nothing I have come across.Wed, 28 Apr 2010 09:39:43 -0500Thanks very much for all the replies, I will try and see what I can do this evening.Good luck and thanks again..https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343070#430343070Thanks very much for all the replies, I will try and see what I can do this evening.Good luck and thanks again..Wed, 28 Apr 2010 08:18:17 -0500Well i've always used that method equimime,just 6 clicks does it including add/remove column.But as far as I can tell the 'dont import column' option just leaves you with the suffix, and not the horse name. And you do have to reset it afterwards othhttps://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343066#430343066Well i've always used that method equimime,just 6 clicks does it including add/remove column.But as far as I can tell the 'dont import column' option just leaves you with the suffix, and not the horse name. And you do have to reset it afterwards othWed, 28 Apr 2010 06:17:13 -0500Or for that matter just don't import the data you don't want. It really is very simple.https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343062#430343062Or for that matter just don't import the data you don't want. It really is very simple.Wed, 28 Apr 2010 06:07:43 -0500Never heard of inserting a column!https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343058#430343058Never heard of inserting a column!Wed, 28 Apr 2010 06:05:29 -0500Problem with text to columns is you may have other data in the next columns, Equimine.co.uk.Sometimes having only a limited knowledge of excel is a bonus , Compound Magic :)https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343054#430343054Problem with text to columns is you may have other data in the next columns, Equimine.co.uk.Sometimes having only a limited knowledge of excel is a bonus , Compound Magic :)Wed, 28 Apr 2010 06:00:07 -0500in that case just do another find replace for (* ,starfishhttps://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343050#430343050in that case just do another find replace for (* ,starfishWed, 28 Apr 2010 05:55:42 -0500Sorry (*) etc should work, but the data provider I tested it on limits the characters column length for the horses name e.g HAIL PROMENADER (IREhttps://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343046#430343046Sorry (*) etc should work, but the data provider I tested it on limits the characters column length for the horses name e.g HAIL PROMENADER (IREWed, 28 Apr 2010 05:39:35 -0500didnt realise the * covers the bracket contents,but doesnt seem to be working even with (*)* ??https://community.betfair.com/general_betting/go/thread/view/94082/23870318/excel-help-please?post_id=430343042#430343042didnt realise the * covers the bracket contents,but doesnt seem to be working even with (*)* ??Wed, 28 Apr 2010 05:33:58 -0500