CONCAT Adding, Removing and then IF 0-9 add this...Help Please

Hi Everyone,   So I think I have gone as far as my brain will carry me in what I want my formula to do. In the attached photo, Column A is the new data where the formula resides. It is Taking the v...