Put A Space Between Sentence Case Words

The Securi firewall will not allow me to post the formula in the reply.

So, here's a sample file that demonstrates this.

Originally Posted by zanshin777

Wow. Huge formula.

Yeah, what you want to do is not so easy to do with a formula!

What is 65:90? What does that formula do?

=ROW(INDIRECT("65:90"))

Generates an array of numbers from 65 to 90 which are used to test for the uppercase letters A to Z.

CHAR(65) = A
CHAR(66) = B
CHAR(67) = C
CHAR(68) = D
etc
etc