GRitchie Posted September 4, 2014 Posted September 4, 2014 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 Posted September 4, 2014 Posted September 4, 2014 just copy and pasted as is and using =CONCATENATE(C2,B2,LEFT(A2,1)) seems to work for me
fairm010 Posted September 4, 2014 Posted September 4, 2014 =CONCATENATE should do the trick. =CONCATENATE(B1,",",B2,",",B3) etc - - - Updated - - - ^ That.
LosOjos Posted September 4, 2014 Posted September 4, 2014 @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 Posted September 4, 2014 Posted September 4, 2014 Could also use the Ampersand if you prefer which is essentially the same: =C2&B2&left(A2,1)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now