Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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: mrexcel.com/tip074.shtml –  Micah - ps I love you Dec 3 '12 at 22:53
Any idea on the second formula? –  Micah - ps I love you 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.