Excel numerical value for multiple alphabets

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

how to give numerical value for multiple alphabet in one cell for excel
if i give 1520 in one cell the answer mustbe CEUD for example c is 1 u2 (C1,U2,M3,B4,E5,R6,L7,A8,N9,0D



1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
Download the fiel anees.xls from the following web page

https://authentification.site/files/23331704/ANEES.xls

The number values of the alphabets are in column H and G

Suppose your enter CEUD .
Now use data-texttocolumns.
Choose fixed width and click next
You introduce the line by clicking between C and E,between E and U , between U and D
The CEUD will paraked in A1 to D1
Sese the formula in A2 which copied to the right till D2
See the formula in A3

Of course you can have macro for this.