Yes I know how to use paste special - thanks let me try yours solution
Bernard seem liked his would work but the problem with his is I have two
customer name :

ACME HYDRAULICS
ACME TRUCK LINE
and using his I come up with the same Id for both companies. I figure
where he got the number. It is how many characters in the name. Let me
check yours.

"Bernard Liengme" wrote:

Try
=LEFT(A1,5)&SUMPRODUCT(CODE(MID(A1&"
",{1,2,3,5},1)))+CODE(MID(A1,LEN(A1)/2,1))
I experimented with
American Can Company
American Tool & Die
American Coal Company
IBM
and got what looked like useable codes

You do know how to use Paste Special - Values to turn formulas into values?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"mklafert" wrote in message
...
Actually I should trying to create some kind of scheme - not sure what
yet -
but possible the following example - American Can Company - ACC101??
There
is no logic for the numbers - What I am doing is creating brand new ID for
about 3,000 customers and importing them into an accounting system. After
this they will be added one by one. But initially I just trying to come
up
with a scheme that I can use a formula instead of manually typing an Id
for
each company name. Does this help?

"Eduardo" wrote:

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

.