Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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:

=CONCATENATE(A1, " ", B1)

For the second, something like:

=MID(D1,1,FIND("@",D1)-1)

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 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .