I have numbers as below. When the numbers end I want everything removed to the adjacent column. I cant use text to columns as there are varying lengths etc. So a code or formula please.
P.S Some may not have letters etc after numbers for example WA2345