Good day!
I'm new to excel and I'm trying to concatenate the text in 3 cells and print in the 4th cell
col1(A) col2(B) col3 (C) col4 (D)
====================================
text1 text2 text3 text1+text2+text3
text2 text3 text4 text2+text3+text4
text5 text6 text7 text5+text6+text7
-- -- --
-- -- --
There are more than 100 rows
I can use this function for each row
=CONCATENATE(A1,B1,C1) and print the result in D1 cell
again I go to the next row
=CONCATENATE(A2,B2,C2) and print the result in D2 cell
I want to select the entire D column and fill each D column cells without going into each D cells and apply the function
Could somebody please help me?
Thank you!
Bookmarks