Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Column A has first name. Column B has last name. I need column C to be "display name" (first name and last name separated by a space). I assume this involves the concatenate function.

Bonus Question: Column D is email address. I need column E to be "username" (everything in email address left of the @ symbol). I assume this involves some regular expression function.

share|improve this question
up vote 5 down vote accepted

For the first part, yes you need CONCATENATE, for example:


For the second, something like:


will give you everything up to the @ of an e-mail address.

share|improve this answer
Yeah, the part I couldn't figure out was to copy the formula down to all of the cells in the column. A shortcut method for doing this is to double-click the fill handle while cell C2 is selected. The fill handle is the darker square dot in the lower right corner of the cell pointer. Source: – Micah Bolen Dec 3 '12 at 22:53
Any idea on the second formula? – Micah Bolen Dec 3 '12 at 22:54
Just updated the answer for the 2nd part – Graham Wager Dec 3 '12 at 22:55

Since variety spices life, here are some other options. Note that the ampersand "&" is the concatenation operator.

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.