Number-letter substitution code in excel?
I'm not good at excel. I'm trying to substitute numbers for letters, but I know I can't use more than seven ifs.
For example:
1 = A
2 = B
3 = C, etc.
I'm not good at excel. I'm trying to substitute numbers for letters, but I know I can't use more than seven ifs.
For example:
1 = A
2 = B
3 = C, etc.
Anonymous
Favorite Answer
Select your range, then Edit / Replace and put 1 in the top box and A in the bottom box and click Replace All.
If you want to do it with a Macro, try this.
Sub Replace
Selection.Replace What:="1", Replacement:="A", Lookat:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub
You would have to do this for each number/letter combination
Anonymous
1111