Excel Help!

[GRitchie]

We're creating a list of usernames for this intake year, however I can't figure out how to make it work.

 

We have the following columns

 

[TABLE=class: grid, width: 500]

[TR]

[TD]Forename[/TD]

[TD]Surname[/TD]

[TD]Intake[/TD]

[TD]Registration[/TD]

[/TR]

[TR]

[TD]Child[/TD]

[TD]One[/TD]

[TD]14[/TD]

[TD]7A[/TD]

[/TR]

[TR]

[TD]Child[/TD]

[TD]Two[/TD]

[TD]14[/TD]

[TD]7D[/TD]

[/TR]

[TR]

[TD]Child[/TD]

[TD]Three[/TD]

[TD]14[/TD]

[TD]7E[/TD]

[/TR]

[/TABLE]

 

 

We then want a final column which follows this pattern:

Intake Year, Surname, First Letter of the Forname

 

 

So, for this list it would be

14OneC, 14TwoC, 14ThreeC

What formula would I use to do this?

 

Please help!!

[sted]

just copy and pasted as is and using =CONCATENATE(C2,B2,LEFT(A2,1)) seems to work for me

[fairm010]

=CONCATENATE should do the trick.

 

=CONCATENATE(B1,",",B2,",",B3) etc

 

- - - Updated - - -

 

^ That.

[LosOjos]

@sted has the right answer.

 

Don't forget to check for duplicates afterwards, easiest way I find is a pivot table, username as the row and also as the data (count), will highlight anyone who you need to tweak slightly

[MrMat]

Could also use the Ampersand if you prefer which is essentially the same:

 

=C2&B2&left(A2,1)