[ms office - 2010] Concatenate multiple cells

[Mark182]

I have large spreadsheet I need to concatenate multiple cells. I have this so far =CONCATENATE(LEFT(B2,1), B2,C2) <-- that works for just one but I need to do over 200 ending at A207,B207 C207

 

Column A = First name (Stu) Column B = Last name (Dent) Column C = number (001234)

 

I have over 200 students I need to do this for and I need the outcome to be = sdent001234 and so on.

 

I just cannot seem to figure it out...

[LosOjos]

If you click on the cell, there'll be a small square bottom right corner, click and drag it (or double click it) and it'll update the formula on each row. Get row 1 right and Excel will do the rest

 

EDIT: also, you can use an ampersand as a shorthand way of implying concatenation, i.e. =LEFT(B2,1)&B2&C2

[Mark182]

HA! school boy error on my part! Been along day here.