With A1 holding: American Can Company
This formula =LEFT(A1,5)&LEN(A1) returns Ameri20
I am not sure where you got the 125 from
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"mklafert" wrote in message
...
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