Forum Discussion
Need help with concatenate formula
I've managed to put together a spreadsheet because I'm trying to reduce time it takes to do manual data entry. I've tried some VBA but my skills are no where near what they should be to use it. My ...
Hi Dave,
This could work
=G21 & " (" & TEXTJOIN(",",TRUE,IFERROR(H25:H37,"")) & "), "&H21
if you use it as array formula (Ctrl+Shift+Enter)
However, better not to return #N/A into H cells