E
Ernie Sersen
I am trying to combine 4 columns of data into 1 column
using =concatenate(A1,B1,C1,D1). It returns a #value
error if any of the cells A1-D1 are blank. I tried
copy/paste special to convert all of the cells to 'value'
with no affect. Please help.
using =concatenate(A1,B1,C1,D1). It returns a #value
error if any of the cells A1-D1 are blank. I tried
copy/paste special to convert all of the cells to 'value'
with no affect. Please help.