Hi there, I'm developing a file that uses the filter function to list lines of data (names, title, etc.) based on a condition, and then off to the side use concatenate to combine 7 columns into different lines (using char(10) to enter each into a new line). But I also want to bold the name and change the font size to Arial 20, while the other text stays Arial 14 and not bolded. From reading around, it seems impossible to do this with concatenate but maybe with VBA?
So instead of:
I've seen an example for doing this below but it's based on an exact string. How can I change this to concatenate data from columns, especially those that are auto populated from a filter function? Thanks for any guidance
Bookmarks