Jul 11 2022 06:55 AM
Hi, I need to be able to use information from other columns to make one full column. for example: Column A is forename Column B is surname, Column D is website address, I need to merge these together to then make column E a complete email address.
Jul 11 2022 07:06 AM - edited Jul 11 2022 07:07 AM
=CONCATENATE(A2;" ";B2;" ";C2) insert in D2
Click on cell with mouse in D2 and drag down as desired.