I need to Remove any space between a 1,2 or 3 digit number immediately followed by a 3 digit number from a trimmed field. As you can see by my attached I have overdone the SUBSTITTUE function. I am looking for a better solution for the SUBSTITUTE..
I am running my SUBSTITUTE() off of column BN (See Columns BP and BQ). I would like to fill Cell BO with BN with Removed spaces between a 1,2 or 3 digit number immediately followed by a 3 digit number from the trimmed field (BN).