Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace formula
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 L771497 I tried writting a if =, but after 10 statements it failed to work, any idea's ?? Thanks again |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace formula
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)&RIGHT(A1,6) -- Kind regards, Niek Otten "Andy the yeti" <Andy the wrote in message ... 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 L771497 I tried writting a if =, but after 10 statements it failed to work, any idea's ?? Thanks again |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace formula
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 L771497 One way: =CHAR(CODE("A")+INT(A1/1000000)-1)&MOD(A1,1000000) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
Find and Replace Formula Links | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Replace worksheet name in formula linked to a different workbook | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |