B bantu New Member Aug 8, 2010 #1 What formula is applicable for adding to cells contaning one text & the other cell contaning number/date.
What formula is applicable for adding to cells contaning one text & the other cell contaning number/date.
oldchippy Active Member Aug 8, 2010 #2 Hi bantu, If your text is in A1 and your date is in B1 then =A1&TEXT(B1," dd-mm-yyyy") Note the space between the first " and dd so that this separates your text from your date
Hi bantu, If your text is in A1 and your date is in B1 then =A1&TEXT(B1," dd-mm-yyyy") Note the space between the first " and dd so that this separates your text from your date
