How can we change the first letter of the word of whole pera in capital letter at a time.
4 Replies
Deepti
(article)
(59 Points)
Replied 04 October 2011
| 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 ( )
Ashish Jain
(.Net Developer)
(641 Points)
Replied 04 October 2011
sorry Deepti
but this formula change only one word of the pera. i want to change whole pera to gather
Deepti
(article)
(59 Points)
Replied 04 October 2011
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 "
Ashish Ojha
(Chartered Accountant)
(469 Points)
Replied 04 November 2011
Paste the Whole para in one cell and then use the above formula...
Recent Topics
- Profit or Loss on Sale of Assets Accounting treatm
- Clarification on RCM on Rent Payment for QRMP Deal
- Reclaimed itc in gstr9
- Gamification in Accounting Software: Boosting Enga
- I want to knw Hsn code and gst rate of resin produ
- Schedule FA clarification
- Income tax on freelance income from crypto
- ITC temporary reversal and reclaim
- Query on Transactions
- Two GSTN under different PAN in same address
Related Threads
CAclubindia
