A acw Jul 21, 2003 #2 Tom Have you looked at concatenating the cells together. =A1&B1&C1 will combine the contents of A1, B1 and C1 together. You will get the same result from =CONCATENATE(A1,B1,C1) Tony
Tom Have you looked at concatenating the cells together. =A1&B1&C1 will combine the contents of A1, B1 and C1 together. You will get the same result from =CONCATENATE(A1,B1,C1) Tony
T Tom Ogilvy Jul 21, 2003 #4 You mean besides =A1&A2&A3& . . . &A49&A50 the answer would be no unless you want to use VBA code. If you mean to concatentate 3 column values per row for 50 rows, put the formula (=A1&B1&C1) in the first cell (D1) and drag fill down the column. Regards, Tom Ogilvy
You mean besides =A1&A2&A3& . . . &A49&A50 the answer would be no unless you want to use VBA code. If you mean to concatentate 3 column values per row for 50 rows, put the formula (=A1&B1&C1) in the first cell (D1) and drag fill down the column. Regards, Tom Ogilvy
