Cell A1 says qwerty12345A
Cell A2 says qwerty12345B
Cell A3 says qwerty12345C
Is there an Excel formula/code that I can use to produce the following:
Cell B1 says qwerty
Cell B2 says qwerty
Cell B3 says qwerty
Cell C1 says 12345A
Cell C2 says 12345B
Cell C3 says 12345C
Thanks