Final Friday Fix: February 2018 Challenge
23 February 2018
Friday is normally our VBA blog day, so for this week’s Final Friday Fix, we’re going to look at a problem that is fairly easy to solve in VBA, but a bit more challenging in Excel…
We had a request from a client to populate an email with the contents from a workbook. Now, we weren’t allowed to use VBA in our solution – they had a standard email macro that they used, and we would need to get the email content looking right by assembling the data into a single target cell in the workbook.
So far, so easy, right?
The challenge comes about because they have a table of data that they want presented neatly. If you’re working with text, it’s pretty straightforward to insert line breaks, but with tables and formatting, it’s a bit harder.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2018/challenges/02-february/fff-feb-2018-image1.png/fc884cf429411e3919a1742a8c186de0.jpg)
So this is the challenge this month – can you set up a formula in C2 (using any additional helper cells you might need), in order for the email macro to produce a result like this?
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2018/challenges/02-february/fff-feb-2018-image2.png/571860120ab1d8735fa48751d84468cc.jpg)
Up for the challenge? You can download the sample file here.
As usual, the answer will be available on Monday!