Hi,
which is the logic behind the numbers

if the numbers is in a list let' say column B and the name of the company is
in column A you can use

=LEFT(A1,5)&B1

"mklafert" wrote:

I am going to create customer ID - Alphanumeric. I have the whole company
names and I was trying to come up with a scheme that I can use an Excel
Function to make the process faster. I thought about Len but not sure - Is
there a command where I can say give me Say the first letter of the company
name and numbers behind it.

Such as

American Can Company - Result of Function - Ameri125

If this is even possible