How can we change the first letter of the word of whole pera in capital letter at a time.
Menu
Excel 2007
Replies (4)
| 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...
Recent Topics :
- FAST DS 2026 query
- Consultation
- E-way notices for FY 22-23
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
Related Topics :
CAclubindia
