Forum Discussion
Solved
Need to concatenate cells but limit number of characters from each original cell
Trying to save time creating new email addresses by combining cells containing first name last name and a number. Trying to do this using the concatenate function but can't work out how to limit the...
If A2, B2 and C2 have these three pieces of information you may try something like this...
=LOWER(LEFT(A2,3)&LEFT(B2,3)&RIGHT(C2,3)&"example.org.uk")
If A2, B2 and C2 have these three pieces of information you may try something like this...
=LOWER(LEFT(A2,3)&LEFT(B2,3)&RIGHT(C2,3)&"example.org.uk")