Hi, I've tried a few different solutions to this one, but not quite there.
I have 3 cells that I need to concatenate with a comma, but only want to include them if they are not blank. Any one (or two) could be blank, and there could be two word entries.
The closest I have is:
Flat, A, 27, Bailey, St
Which I need to come out as:
Flat A, 27, Bailey St
using the formula:
=SUBSTITUTE(TRIM(BV6 & " " & BW6 & " " & BX6), " ", ", ")
Can this be done without a UDF? What if there are more than 3 cells?
Thanks in advance.
Bookmarks