How do I code using a cell?
Closed
TSCGCobra043
Posts
5
Registration date
Monday December 14, 2015
Status
Member
Last seen
December 16, 2015
-
Dec 14, 2015 at 04:48 PM
Blocked Profile - Dec 16, 2015 at 06:20 PM
Blocked Profile - Dec 16, 2015 at 06:20 PM
Related:
- How do I code using a cell?
- Battery reset code - Guide
- Samsung volume increase code - Guide
- How to get whatsapp verification code online - Guide
- Cs 1.6 code - Guide
- Samsung keypad reset code - Guide
Dec 15, 2015 at 11:35 AM
Dec 15, 2015 at 02:49 PM
It requires a custom function to do this as loops are required to pull out the numbers from cell to lookup the associated letter add it to a string, skip the comma (or delimiter) and then move onto the next number in the cell. Repeat until there are no more numbers. Display the string in the cell.
It will help if you posted the cell ranges of your letter/number cells, or even a screenshot or example spreadsheet
Dec 15, 2015 at 04:59 PM
Dec 15, 2015 at 08:44 PM
In a module put the following code:
This assumes the following (as I do not know the layout you are using):
1.Column A contains the number.
2.Column B contains the character
The Range contains 31 rows as the list of characters includes other non-alphabetic characters such as Space, #, $, as these may be useful. Add other characters as you need but adjust the range accordingly.
To use the function, lets say the code you want to convert is in cell D2, in another cell, put:
Dec 16, 2015 at 10:42 AM