mbbx5va2
09-08-2014, 10:34 AM
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:
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: