Hello and I apologise in advance if this is a stupid newbie question (but thats what i am).
I have an Excel sheet i'm working on, for tracking customers. I currently enter their first and last names in separate cells and have a formula that extracts the first few letters of each, to make up the customer code.
the formula is =LEFT(E2,3)&LEFT(D2,2)
this returns the first three letters of the surname and the first two of the first name and combines them to read one customer code
e.g.
Michael Townsend would return as TowMi
My issue is, I want these to be all capitals e.g. TOWMI and don't know how to do it in the one cell
I have been using the formula =UPPER(B2) in a separate cell and using this as the Customer ID but this seems cumbersome and inefficient.
Is there any way to combine the two formulas in the one cell, or is there a better method to return the result i want?
Thanking you in advance
Cal
I have an Excel sheet i'm working on, for tracking customers. I currently enter their first and last names in separate cells and have a formula that extracts the first few letters of each, to make up the customer code.
the formula is =LEFT(E2,3)&LEFT(D2,2)
this returns the first three letters of the surname and the first two of the first name and combines them to read one customer code
e.g.
Michael Townsend would return as TowMi
My issue is, I want these to be all capitals e.g. TOWMI and don't know how to do it in the one cell
I have been using the formula =UPPER(B2) in a separate cell and using this as the Customer ID but this seems cumbersome and inefficient.
Is there any way to combine the two formulas in the one cell, or is there a better method to return the result i want?
Thanking you in advance
Cal
