Combining fields in Excel?

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?
ccarmichael7Asked:
Who is Participating?
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
alternate, shortcut versions of Miss_S's code:

(First Name) (Last Name)
=B5&" "&C5

(First Name initial) (Last Name)
=LEFT(B5,1)&" "&C5

-Glenn
0
 
Missus Miss_SellaneusConnect With a Mentor Commented:
Assume B5 is first name, C5 is last name:

(first name) (last name):
=CONCATENATE(B5," ",C5)

(first initial of firstname)(lastname):
=CONCATENATE(LEFT(B5,1)," ",C5)
0
 
ccarmichael7Author Commented:
Thanks for both of your help.  I am splitting the points as both answers are right, but one is more optimized.
0
All Courses

From novice to tech pro — start learning today.