Dear Experts

I have too many wording which on columns "w" to wanna get SPACE base on a numbers TO SPLIT.

For example
"KERRYWAREHOUSE *2KERRYWAREHOUSE*3KERRYWAREHOUSE*4"

Result
"KERRYWAREHOUSE *2 KERRYWAREHOUSE*3 KERRYWAREHOUSE*4"

can it be do by macros ?
please help as i highly appreciate