Excel numerical value for multiple alphabets
Closed
Anees
-
10 Jul 2010 à 12:23
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 10 Jul 2010 à 22:29
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 10 Jul 2010 à 22:29
Related:
- Excel numerical value for multiple alphabets
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Split excel sheet into multiple files - Guide
- Vat calculation excel - Guide
- Excel multiple lines in one cell - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
10 Jul 2010 à 22:29
10 Jul 2010 à 22:29
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.
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.
