Split cell containing numbers and text

Hi

I have data which is being web pasted to my template sheet daily, I need data split formula which seperates and puts to end of sheet not in next cell.

Split needs to be first 2 charactors example C6Hch ---------> C6 Hch

I have attached a sheet on how the text/value would appear, Grey area is data, Yellow is the destination split.

Thanks

wow so easy, i have alot of stuff needs this, you just saved me alot of time daily

Thank you

wow so easy

I have alot of stuff needs this, you just saved me alot of time daily

Thank you