M
mh
I would like to combine the words from different cells into one cell -
sometimes 1 or 2 cells are left empty
Example
A1 A2 A3 A4 A5
Peter Simon Derek Empty Kent
combine into one cell marking all
=A1&","&A2&","&A3&","&A4&","&A5
Should say
Peter, Simon, Derek, Kent (without extra , or space for empty cell included)
Could somebody help me with formula for this? would be greatly appreciated
sometimes 1 or 2 cells are left empty
Example
A1 A2 A3 A4 A5
Peter Simon Derek Empty Kent
combine into one cell marking all
=A1&","&A2&","&A3&","&A4&","&A5
Should say
Peter, Simon, Derek, Kent (without extra , or space for empty cell included)
Could somebody help me with formula for this? would be greatly appreciated