software

Hi, thanks in advance for any help...

I have a series of 8 number codes (eg 12771497) that starts with one of the
numbers from 1 to 26, I would lile to replace for example 1 with A, 2 with B,
3 with C, 26 with Z etc

so it would change from 12771497 gt; L771497

I tried writting a if =, but after 10 statements it failed to work, any
idea's ??

Thanks again
Hi Andy,

If it's always 8 digits, how do we now whether to take 1 or 2 start digits?

iow, why is your example not A2771497?

For your example:

=CHAR(LEFT(A1,2) 64)amp;RIGHT(A1,6)

--
Kind regards,

Niek Otten

quot;Andy the yetiquot; lt;Andy the gt; wrote in message
...
gt; Hi, thanks in advance for any help...
gt;
gt; I have a series of 8 number codes (eg 12771497) that starts with one of
gt; the
gt; numbers from 1 to 26, I would lile to replace for example 1 with A, 2 with
gt; B,
gt; 3 with C, 26 with Z etc
gt;
gt; so it would change from 12771497 gt; L771497
gt;
gt; I tried writting a if =, but after 10 statements it failed to work, any
gt; idea's ??
gt;
gt; Thanks again
gt;
gt;
gt; I have a series of 8 number codes (eg 12771497) that starts with one
gt; of the numbers from 1 to 26, I would lile to replace for example 1
gt; with A, 2 with B, 3 with C, 26 with Z etc
gt;
gt; so it would change from 12771497 gt; L771497

One way:
=CHAR(CODE(quot;Aquot;) INT(A1/1000000)-1)amp;MOD(A1,1000000)