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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Missus Miss_SellaneusCommented:
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
Glenn RayExcel 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ccarmichael7Author Commented:
Thanks for both of your help.  I am splitting the points as both answers are right, but one is more optimized.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.