LinkBack URL
About LinkBacks
Hi
I have capital case word followed by sentence case in Column A.I need to Split capital word and sentence case separately.
PFA
Thanks
Hi
I have capital case word followed by sentence case in Column A.I need to Split capital word and sentence case separately.
PFA
Thanks
if you want to split Capital and Sentence case then third line should have
FLAT TOP GRILLED QUESADILLAS NOT (Smoked Chicken) along with the line
Last edited by hemesh; 03-26-2014 at 02:11 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
okay..i try to make it capital then is it possible??
Hi Hemesh
This formula also gets the first letter of the word in the sentence case
If you want to Split Capital and sentence case then copy paste below in B1 hold control and shift then hit enter to make it array formula
=SUBSTITUTE(LEFT(A1,MATCH(0,(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>=32)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<98),0)-2),"(","")
and drag down
in C1
=RIGHT(A1,LEN(A1)-LEN(B1))
Last edited by hemesh; 03-26-2014 at 02:37 AM.
Its ok for me even those lines are skipped i ll do it manually
Find attached !
Thanking you
You are Welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks