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!