ExcelBanter - formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formula help (https://www.excelbanter.com/excel-programming/308191-formula-help.html)

scrabtree23[_2_]

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?

Tom Ogilvy

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?

All times are GMT +1. The time now is 01:18 PM.