I have some very large files where some columns have the text without any
spaces. However they are using CAPS for all first letters. For example:

TheBookStore
WalmartDiscountStores

Is there a formula or macro that can add a space before every CAP (PROPER)
letter so that it will read:

The Book Store
Walmart Discount Stores

Thanks,
Althea