Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
C.G. Triggs
C.G. Triggs asked in Computers & InternetProgramming & Design · 1 decade ago

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.

2 Answers

Relevance
  • Anonymous
    1 decade ago
    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
    5 years ago

    1111

Still have questions? Get your answers by asking now.