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
In my CONCATENATE formula problem I am combining selections made in a few dropdowns in cells, one of which is a date. When I combine the answers, the date always shows up as the datevalue (example: 11/26/2018 shows up as 43430). I need that part to show as "mm-dd-yyyy" showing the actual date. How do I do this?
