New Posts For Thread: Open Office spreadsheet help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/26437885/open-office-spreadsheet-help-pleaseI would like to delete all the blank rows and then combine the text in cell A3 with the text in cell A2, the text in cell A6 with A5, etc., etc. I think the answer to part two of my question may be to use the CONCATENATE function but I need to get rMany thanks modk and Compound Magic - job done!Cheers Stow_judge - some useful info in your reply.Apologies to all three of you for not conveying my thanks sooner but I've been off-line for most of the day. Thanks again.https://community.betfair.com/general_betting/go/thread/view/94082/26437885/open-office-spreadsheet-help-please?post_id=477769441#477769441Many thanks modk and Compound Magic - job done!Cheers Stow_judge - some useful info in your reply.Apologies to all three of you for not conveying my thanks sooner but I've been off-line for most of the day. Thanks again.Sun, 12 Dec 2010 11:13:28 -0600Another alternative is to do this first ~In Cell G2 this formula =IF(F2="";"";A2&" "&A3) Then fill down, copy G2:G500, Then paste special values only, Select A2, paste, then delete column GThen do as modk suggested for blankshttps://community.betfair.com/general_betting/go/thread/view/94082/26437885/open-office-spreadsheet-help-please?post_id=477740713#477740713Another alternative is to do this first ~In Cell G2 this formula =IF(F2="";"";A2&" "&A3) Then fill down, copy G2:G500, Then paste special values only, Select A2, paste, then delete column GThen do as modk suggested for blanksSun, 12 Dec 2010 06:16:52 -0600and to remove the blank rows, Data-Standard Filter and set it to Column A = BlankThen just delete those rowshttps://community.betfair.com/general_betting/go/thread/view/94082/26437885/open-office-spreadsheet-help-please?post_id=477738789#477738789and to remove the blank rows, Data-Standard Filter and set it to Column A = BlankThen just delete those rowsSun, 12 Dec 2010 05:48:13 -0600Not sure if this suits, but, if you copy your data to sheet2, you can use an expression to bring the text together in sheet1.= Sheet2!A2&Sheet2!C2&Sheet2!E2&Sheet2!G2&Sheet2!I2You can also enter spaces by using this within the expression & " " &Databhttps://community.betfair.com/general_betting/go/thread/view/94082/26437885/open-office-spreadsheet-help-please?post_id=477738553#477738553Not sure if this suits, but, if you copy your data to sheet2, you can use an expression to bring the text together in sheet1.= Sheet2!A2&Sheet2!C2&Sheet2!E2&Sheet2!G2&Sheet2!I2You can also enter spaces by using this within the expression & " " &DatabSun, 12 Dec 2010 05:44:59 -0600I would like to delete all the blank rows and then combine the text in cell A3 with the text in cell A2, the text in cell A6 with A5, etc., etc. I think the answer to part two of my question may be to use the CONCATENATE function but I need to get rhttps://community.betfair.com/general_betting/go/thread/view/94082/26437885/open-office-spreadsheet-help-please?post_id=477730249#477730249I would like to delete all the blank rows and then combine the text in cell A3 with the text in cell A2, the text in cell A6 with A5, etc., etc. I think the answer to part two of my question may be to use the CONCATENATE function but I need to get rSun, 12 Dec 2010 03:07:56 -0600