Excel enables us to convert letters to numbers and numbers to letters. In this tutorial, we will learn how to convert letters to numbers and vice versa using the SUBSTITUTE function, COLUMN function, and VBA. Figure 1 – Example of how to convert column letter to a number How to...
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.