I need to capitalize only the very first word of each sentence in a paragraph.
How can I do this? Thanks!
I need to capitalize only the very first word of each sentence in a paragraph.
How can I do this? Thanks!
Have you looked at using the "Proper" formula?
Not sure of your layout but this might be a good start?
Proper() will cap the 1st letter of every word, not just the 1st word
perhaps something like this?
=SUBSTITUTE(A2,LEFT(A2,1),UPPER(LEFT(A2,1)))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this UDF....
![]()
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
[QUOTE=FDibbins;3262492]Proper() will cap the 1st letter of every word, not just the 1st word
Ah, yeah.
Learnt something new today too. Thanks for the substitution lesson![]()
=get(word)
You could expand on this, but I'd go with a UDF.
This handles the punctation marks, "Full Stop", "Question Mark", and "Exclamation Mark" with carriage return thrown in for good luck ...
Drag C3 Across as far as you like
Formula:
Please Login or Register to view this content.
Then in B2 expand on this, I have only allowed for 3 sentences.
Formula:
Please Login or Register to view this content.
Last edited by Marcol; 06-01-2013 at 12:45 PM. Reason: Bad spelling
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
thanks everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks