Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help
In "column A" in "Cells 1 and 2" I have the following
data: A1234 and B4321 respectively. I need to have a formula to drag down "column B" that would convert the letters to numbers as follows: A1234 would become 11234 and B4321 would become 24321. Help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help
=((CODE(LEFT(A1))-64) & RIGHT(A1,LEN(A1)-1))*1
then drag fill down the column. -- Regards, Tom Ogilvy "scrabtree23" wrote in message ... In "column A" in "Cells 1 and 2" I have the following data: A1234 and B4321 respectively. I need to have a formula to drag down "column B" that would convert the letters to numbers as follows: A1234 would become 11234 and B4321 would become 24321. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |