Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

On a spreadsheet, how to get data from 3 columns into 1 column - eg, you have 3 columns with "1st name", "2nd name" and "Surname" - change to 1 column?

user-image
Question added by Ruma Alleck , Senior Secretary , Le Bocage International School
Date Posted: 2016/01/14
Shyra Love Serapio
by Shyra Love Serapio , HR Business Partner , Metropolitan Bank and Trust Company

Hi Ruma, you have to use the formula concatenate to combine together3 columns to1.

More Questions Like This