Solved

Combining fields in Excel?

Posted on 2014-07-29
3
347 Views
Last Modified: 2014-07-29
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?
0
Comment
Question by:ccarmichael7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Assisted Solution

by:Missus Miss_Sellaneus
Missus Miss_Sellaneus earned 250 total points
ID: 40227835
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
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 250 total points
ID: 40227856
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
 

Author Closing Comment

by:ccarmichael7
ID: 40227870
Thanks for both of your help.  I am splitting the points as both answers are right, but one is more optimized.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question