Take data from one column and separate out numbers and letters into two new columns

Okay so I have a column of data that has one of the following four configurations two numbers (ex. 20), two numbers and a letter (ex. 16M), three numbers (411), three numbers and a letter (234P). The letters are always at the end if there is a letter (there are a couple instances where there are two letters but I could go in and hand change those if that causes a problem).

I want to separate out the numbers and letters so that one column would have: 20,16,411,234 and the other column would have (blank),M, (blank),P ( I don't want it to say blank I just want it to be empty)

What should I do?
If a solution involved adding a leading 0 to the two numbers I would be fine with that as that will be my next step.

Thanks!

Thanks for the reply - the first part of it worked great - The numbers are separating just fine and showing up in the appropriate column. However, the second part is leaving me with a strange result. It's putting numbers in the column where the letters should be. For example 16M was my original entry and it is separating out into 16 and then 7 (not m). 17M has turned into 17 and then 8 (not M), 235P is now 235 and 4 (not P)....any insights?

Thanks Ace_XL. Your version worked perfectly. Sorry but when I entered the first one I wasn't getting the same results, maybe the whole --Right part? Anyways, thank you very much!