Excel numerical value for multiple alphabets
Closed
Anees
-
Jul 10, 2010 at 12:23 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 10, 2010 at 10:29 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 10, 2010 at 10:29 PM
Related:
- Excel numerical value for multiple alphabets
- Allow multiple downloads chrome - Guide
- Excel date format dd.mm.yyyy - Guide
- Kernel for excel - Download - Backup and recovery
- How to delete multiple files at once - Guide
- Excel free download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 10, 2010 at 10:29 PM
Jul 10, 2010 at 10:29 PM
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.
