Hi, looking for some help. Have a need to compile employee names from multiple rows into just one cell. I use eg A1&" "&A2&" "&A3 etc but when there is a row that is empty (Which will happen) it will still add a space. So when I call on this for refrencing this cell to email the range with a separate VBA code it throws off the Names and places spaces where there is no names. What I would like is a formula where it will compile the names from the rows unless the row is blank.
Thanks for any support in advance
Reply With Quote
