G
Guest
I want to be able to combine the contents of a range of cells into one cell.
Using the concatenate command includes spacing and/or characters for blank
cells.
ex: , , , , John Smith, , Joe Frazier, , etc.
Using the substitute trim commands puts excess characters inside cell values
ex: John, Smith, Joe, Franzier etc.
I want to be able to take the contents of non-blank cells in a row (15
columns) and combine them with a space and comma between the non blank cell
values.
Please help!
Using the concatenate command includes spacing and/or characters for blank
cells.
ex: , , , , John Smith, , Joe Frazier, , etc.
Using the substitute trim commands puts excess characters inside cell values
ex: John, Smith, Joe, Franzier etc.
I want to be able to take the contents of non-blank cells in a row (15
columns) and combine them with a space and comma between the non blank cell
values.
Please help!