We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
I 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 rid of the blank rows first!
Thanks in advance.
[url=http://www.bbcode.org/images/lubeck.jpg][/url]
I think the answer to part two of my question may be to use the CONCATENATE function but I need to get rid of the blank rows first!
Thanks in advance.
[url=http://www.bbcode.org/images/lubeck.jpg][/url]
sort by:
Show
per page
Replies: 4
|
By:
Not 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!I2 You can also enter spaces by using this within the expression & " " & Databases do these things easily as well. |
|
By:
and to remove the blank rows, Data-Standard Filter and set it to
Column A = Blank Then just delete those rows |
|
By:
Another 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 G Then do as modk suggested for blanks |
|
By:
Many 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. |