Function To Auto Generate 40 Characters Length Name In Excel?
When user enters 3 or 4 values in different cells, the function must auto generate a 40 character name, in Excel
Example
User enters the following information in
Cell B2: 1000 Kilograms must convert to 1T (1 Tonne)
Cell C2: Mitsubishi (Manufacturer)
Cell D2: 3456MRF-RT7890 Graffiti Remover (Model number)
Cell A1: 40 character length auto generated name that has parts of (cell B2 + cell C2 + cell D2)
If the users only enter a names that are less than 40 characters then the function must auto generate all the characters.
I am not an expert in excel so ” Thanks in Advance “
sharethis
=LEFT(CONCATENATE( SUBSTITUTE($B$2, ” Kilograms”, “”) / 1000&”T”, C2, D2), 40)