View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mklafert mklafert is offline
external usenet poster
 
Posts: 6
Default What function to use? Len?

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