IF function within lengthy & (CONCATENATE) Formula

[caj1980]

OK, trying to build a formula that will concatenate (using & instead of the concatenate formula) from a range of cells. I only want it to include cells that have text and ignore blank cells.

Formula is in cell G7 on the "DATA and CALCS" sheet. Currently the formula includes all of the cells in the range but I need it modified so it only includes cells that are filled in on the User Form.

Spreadsheet available here: https://indepmo-my.sharepoint.com/❌...pPnbZ9QR6aL_MBPPAIdZSnqmEgpADzrABT0A?e=HtKkDc

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

BTW, your link does not work for me. I get: "You cannot access this right now"
Have you tried XL2BB?