New Posts For Thread: EXCELL HELP PLEASEhttps://community.betfair.com/poker/go/thread/view/94146/23655762/excell-help-pleaseBeen yonks since ive used this so cant remember a thing... Say you have data in the form 1MR A Smith024 111111101 ANY ADDRESS, Coventry, West Midlands, POSTCODE2MR B Smith024 222222102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE3MR C Smitcant seem to get it to do it mandy... im not sure if its index function instead..https://community.betfair.com/poker/go/thread/view/94146/23655762/excell-help-please?post_id=423955070#423955070cant seem to get it to do it mandy... im not sure if its index function instead..Thu, 21 Jan 2010 15:57:26 -0600$ signs used i think either side of the constants and the variables left alone and excell should autofill the difference neededhttps://community.betfair.com/poker/go/thread/view/94146/23655762/excell-help-please?post_id=423955062#423955062$ signs used i think either side of the constants and the variables left alone and excell should autofill the difference neededThu, 21 Jan 2010 15:41:57 -0600little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheetif you have a1=Sheet6!A1a2=Sheet6!A6a3=Sheet6!A11and i want to carry on this series downwards eg in a4 i would have =Sheet6!A16 and then A21https://community.betfair.com/poker/go/thread/view/94146/23655762/excell-help-please?post_id=423955058#423955058little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheetif you have a1=Sheet6!A1a2=Sheet6!A6a3=Sheet6!A11and i want to carry on this series downwards eg in a4 i would have =Sheet6!A16 and then A21Thu, 21 Jan 2010 15:38:45 -0600'Text to Columns' is the tool you are looking for should be under the 'Data' headerhttps://community.betfair.com/poker/go/thread/view/94146/23655762/excell-help-please?post_id=423954998#423954998'Text to Columns' is the tool you are looking for should be under the 'Data' headerThu, 21 Jan 2010 08:06:41 -0600Been yonks since ive used this so cant remember a thing... Say you have data in the form 1MR A Smith024 111111101 ANY ADDRESS, Coventry, West Midlands, POSTCODE2MR B Smith024 222222102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE3MR C Smithttps://community.betfair.com/poker/go/thread/view/94146/23655762/excell-help-please?post_id=423954994#423954994Been yonks since ive used this so cant remember a thing... Say you have data in the form 1MR A Smith024 111111101 ANY ADDRESS, Coventry, West Midlands, POSTCODE2MR B Smith024 222222102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE3MR C SmitThu, 21 Jan 2010 07:48:39 -0600