We are migrating to office365. I have a list of our users first name and last name in csv format. However I need to do a little scripting to get all the fields I need formatted properly.
We have: (first name),(lastname)
We need to combine these two fields to create the following new fields:
(first initial of firstname)(lastname)
(first name) (last name)
Can anyone help with a formula that will create these two new fields?