One of our clients that we administrate on 365 has their display name in the following format: “Surname, Firstname”
When you come to add users to 365 in bulk, you need a .csv file populated with the relevant info.
I was presented with a list of 1st names and their corresponding surnames, but man, I didn’t want to sit and type out all the above names.
Using the formula =CONCATENATE(A2,”, “,B2) in column C2 – I let Excel do the hard work.
Leaving me enough time to get a cup of tea 🙂