Excel 2007

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...