G
Guest
When using concatenate if I have cells that are empty in
that row how can I disregard including the empty cell,
without typing function in manually for each row ?
Example:
Col 1 Col 2 Col 3 Col 4 Col 5
Dan Dave Paul Sue
Function I use is
=CONCATENATE(A1,",",B1,",",C1,",",E1,",",)
Results I receive are: Dan,,Dave,Paul, Sue
Like to see: Dan, Dave, Paul, Sue
that row how can I disregard including the empty cell,
without typing function in manually for each row ?
Example:
Col 1 Col 2 Col 3 Col 4 Col 5
Dan Dave Paul Sue
Function I use is
=CONCATENATE(A1,",",B1,",",C1,",",E1,",",)
Results I receive are: Dan,,Dave,Paul, Sue
Like to see: Dan, Dave, Paul, Sue