CONCATENATE
On Sep 10, 3:33*pm, art wrote:
Try this and finish it for the rest of the row:
=CONCATENATE(IF(A1="","",A1),"/",IF(B1="","",B1),"/",IF(C1="","",C1),"/",IF (D1="","",D1),"/",IF(E1="","",E1))
Is this what you meant?
" wrote:
Hi,
I have a file that from Column A to AD and Rows 5 to 98 has formulas
that is linked to a data in different worksheet, some cells are only
numbers and some have text and numbers and some are blank, I am trying
to "CONCATENATE" each row to a cell with a "/" in between but it
should leave out the blank cells.
I would appreciate for any help.
Thanks,
Art, that will still leave him with a "//" for blank values.
Better -
=CONCATENATE(IF(A1="","",CONCATENATE(A1,"/")),IF(B1="","",CONCATENATE(B1,"/"))),IF(C1="","",CONCATENATE(C1,"/")))...
But Excel will not allow him to enter enough arguments for 30 columns
of data in this manner.
Steven
|