Hello All,
I need help!!! I am trying to write a formula that replaces the letter "a" with the number "1", "b" with "2", "c" with "3", etc.... The individual formula of (ex.) =SUBSTITUTE([Column3]1, "a", "1") is easy enough, but for whatever reason I can't seem to figure out how to nest it with the rest of the letters and numbers. I have tried every different way I can think of, but nothing seems to work. My end goal is that "abc" automatically becomes "123" in the target cell. I do not however want to limit how many times each particular letter can be replaced. That way if I have "abcbacb" it turns into "1232132". Any ideas???
Thanks!