parsing without spaces... MyCompanyRocks how to make this My Company Rocks...

I'm having an issue that is causing me headaches. I have a list of companies I need to load into a table from excel. Column A has the company name. 75k rows. Each name has been jumbled into one long word like the following:

MyCompanyRocks
CompanyCompanyCompanyCompany
AnotherCompanyNameJumbledTogether

So, basically each company name has been squeezed together. Each part of the name starts with a Capital letter.

Is there a way to parse by capital letter or separate these names again by using capital letter?

I need to get from this: MyCompanyRocks
to this: My Company Rocks

Text to column doesn't work. Any help would be wonderful.

Thanks so much for your time and knowledge

John