PDA

View Full Version : Solved: Compile names



wilg
10-24-2010, 05:58 PM
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

mbarron
10-24-2010, 06:19 PM
Surround your concatenation with the trim function:
=TRIM(A1&" "&A2&" "&A3)

wilg
10-24-2010, 07:43 PM
Wow! Perfect. Thanks so much.