How can we change the first letter of the word of whole pera in capital letter at a time.
How can we change the first letter of the word of whole pera in capital letter at a time.
| Originally posted by : Ashish Jain | ||
 |
How can we change the first later of the word of whole pera at a time. |
 |
Hi Ashish,
Use = PROPER ( )
sorry Deepti
but this formula change only one word of the pera. i want to change whole pera to gather
Dear Ashish,
See the example below. This formula convertes first leter of each word of the selected text
"But This Formula Change Only One Word Of The Pera. I Want To Change Whole Pera To Gather "
Paste the Whole para in one cell and then use the above formula...
CAclubindia
