Uncategorized
I have this Excel spreadsheet. Believe it or not, that is not, in and of itself, the annoyance.
I have data in columns A & B, and column C consists of this formula:
=if(countblank($a2:$b2)=0,concatenate($b2, ", §", $a2), "")
This works perfectly, with one small exception: the formatting in cell $b2 (partial italics) is lost in the concatenation. Since I have a few hundred rows to deal with, hand-formatting (again, since I originally hand-formatted $b2 to begin with) is really annoying.
Yes, I know that Excel isn’t a word processor, and that formatting is for word processors. But, damnit, this should work.
Yeah. Ideally, this would be in a database, but that required more effort than I was willing to put into it. And, honestly, even with having to hand-format stuff, a real DB would probably still be more effort. But man, I wish Excel wasn’t stupid. 🙂