Extract Separate Numbers From Letters

I've found several posts but none seem to peform this varying function:

EX12345678....Result in Col B: "EX" and Result in Col C: "12345678"
RTZZ4567.......Result in Col B: "RTZZ" and Result in Col C: "4567"

The problem with the formulas I've got specifically define - pulling let's say LEFT, 2 characters.....when, I may need it to pull 2 or 3 or 4. I found something that's smart enough to look for ONLY ALPHA and strip those out and place them into one column. =LEFT(A1,MIN( FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1)

* I need something that's smart enough to look for ONLY NUMERIC. no matter how long the string is...and place those in Column C (like I mention in the example at the top).