Combine Data From Columns in Excel

Say you have two columns in Excel, one containing first names and one containing last names and you want to combine each first and last name into a cell.  Below are formulas for two different ways of combining the data.

 

A

B

1

First Name

Last Name

2

Nancy

Davolio

3

Andrew

Fuller

 

Formula

Description (Result)

 

=A2&" "&B2

Combines the names above, separated by a space (Nancy Davolio)

 

=B3&", "&A3

Combines the names above, separated by a comma (Fuller, Andrew)





HelpCorps

Better known as Student Technology Assistants, or STAs, our HelpCorps students provide support to fellow students in Schertz and Kratz-Miller labs. Our STAs also staff the campus HelpDesk, providing telephone and walk-in support to faculty, staff, and students.

Our preference is to hire students who have been on campus and worked in the student labs for at least one semester, since this helps them to help others. We look for individuals who have familiarity with computers and their operation, but we especially like to hire people who enjoy helping others. We offer STA training seminars every fall, as well as ongoing assistance from our professional ITS staff, to help our students provide the best possible support to the campus.

Other characteristics we look for are:

  • an ability to think creatively and problem solve
  • an upbeat, friendly, customer service attitude
  • enthusiasm for continual growth and learning
  • ability to communicate with others, and be understood by them over the telephone, in English
  • a professional demeanor and appearance

If you are interested in working in a technology environment, providing quality customer service, and being a member of our team, please complete an STA job application . You may send email to Pamela Kistler-Osborne at  if you have any questions about HelpCorps.

Login Button
Powered by Caravel CMS, © 2003-2009 Mennonite.net.