Turning part of substring into capital for text data

[mbbx5va2]

Suppose I have a string with an arbitrarily large number of spaces inbetween where the data is text. So it can be something like this sentence say. Any ideas which formulas would enable me to turn a lower case letter into a capital letter for a specific element of specific substrings?

So take the sentence: 'I am coming back tomorrow'

Then here I want to just use a function to give the output: 'I Am Coming Back Tomorrow'

Here the sentence contains just five words but I need the function to perform the same operation (i.e put capital letter at front of every word ) on an unknown number of words in a sentence.

Cheers
:hi:

[mancubus]

A1: i am coming back tomorrow


formula in B1:

=PROPER(TRIM(A1))

B1 formula result: I Am Coming Back Tomorrow

[mbbx5va2]

A1: i am coming back tomorrow


formula in B1:

=PROPER(TRIM(A1))

B1 formula result: I Am Coming Back Tomorrow


That's perfect thank you! :)

[mancubus]

you are welcome.

thanks for marking the thread as solved.