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?
 - Cs 1.6 code - Guide
 - Samsung volume increase code - Guide
 - Lava reset code ✓ - Phones, PDA & GPS Forum
 - Battery reset code - Guide
 - Ninja up code ✓ - Android Forum
 
        
    
    
    
    
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:
Function ConvertCode(code As Range) As String Start = 1 While Start < Len(code) Pos = InStr(Start, code, ",", vbTextCompare) If Pos = 0 Then Pos = Len(code) + 1 StrValue = Mid(code, Start, Pos - Start) Start = Pos + 1 Set rng1 = Range("A1:A31").Find(StrValue, , xlValues, xlWhole) StrValue = rng1.Offset(0, 1) ConvertCode = ConvertCode & StrValue Wend End FunctionThis 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