Is it possible to merge date from two columns into one column? How
J JulieD Oct 26, 2004 #2 Hi Rena not sure what you're after here .. but you could copy & paste the second column's data onto the bottom of the first column? if you're working with lists that contain duplicates you might like to check out Chip Pearson's web site http://www.cpearson.com/excel/duplicat.htm Hope this helps Cheers JuileD
Hi Rena not sure what you're after here .. but you could copy & paste the second column's data onto the bottom of the first column? if you're working with lists that contain duplicates you might like to check out Chip Pearson's web site http://www.cpearson.com/excel/duplicat.htm Hope this helps Cheers JuileD
M Max Oct 26, 2004 #3 rena said: Is it possible to merge date from two columns into one column? How Click to expand... Assuming you mean "data" as per your subject line, say, combining "Name1" and "Name2" in cols A and B into col C Name1 Name2 RenaBubley Roy Rogers etc Try in C2: =TRIM(A2&" "&B2) Copy down See also Debra Dalgleish's nice coverage of "Combining Data" at: http://www.contextures.com/xlCombine01.html
rena said: Is it possible to merge date from two columns into one column? How Click to expand... Assuming you mean "data" as per your subject line, say, combining "Name1" and "Name2" in cols A and B into col C Name1 Name2 RenaBubley Roy Rogers etc Try in C2: =TRIM(A2&" "&B2) Copy down See also Debra Dalgleish's nice coverage of "Combining Data" at: http://www.contextures.com/xlCombine01.html