{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sentence Case - Examples","Capitalize first letter","Uppercase to sentence case","Change text to sentence case","Sentence case VBA"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sentence Case - Examples","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,1,14,2],[3,1,3,5],[5,1,5,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[]
[]
[null,"Sample Workbook to Sentence Case in Excel"]
[]
[null,"The workbook shows how to convert text to sentence case in Excel with traditional formulas, regexes, and VBA macro."]
[null,"Author","Ablebits.com"]
[null,"Last update","2026-04-16"]
[null,"Tutorial URL","How to change text to sentence case in Excel "]
[]
[null,"Examples:"]
["• ","Formula to capitalize first letter in text string"]
["• ","Formula to change ALL CAPS to sentence case"]
["• ","Formula to change text to sentence case"]
["• ","VBA to convert text to sentence case"]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Capitalize first letter","index":1,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel formula to capitalize first letter in text string"]
["Source data",null,"Sentence case"]
["the cell contains just 1 sentence.",null,{"$f":"UPPER(LEFT(A3:A25))&MID(A3:A25,2,LEN(A3:A25)-1)","v":"The cell contains just 1 sentence."}]
["the cell contains proper nouns such as Rome.",null,"The cell contains proper nouns such as Rome."]
["the cell contains abbreviations such as ASAP.",null,"The cell contains abbreviations such as ASAP."]
["better late than never.",null,"Better late than never."]
["actions speak louder than words.",null,"Actions speak louder than words."]
["practice makes perfect.",null,"Practice makes perfect."]
["when in rome do as the romans do.",null,"When in rome do as the romans do."]
["fortune favors the bold.",null,"Fortune favors the bold."]
["honesty is the best policy.",null,"Honesty is the best policy."]
["the pen is mightier than the sword.",null,"The pen is mightier than the sword."]
["knowledge is power.",null,"Knowledge is power."]
["elementary, my dear Watson.",null,"Elementary, my dear Watson."]
["necessity is the mother of invention.",null,"Necessity is the mother of invention."]
["beauty is in the eye of the beholder.",null,"Beauty is in the eye of the beholder."]
["the grass is always greener on the other side.",null,"The grass is always greener on the other side."]
["you reap what you sow.",null,"You reap what you sow."]
["two wrongs do not make a right.",null,"Two wrongs do not make a right."]
["the squeaky wheel gets the grease.",null,"The squeaky wheel gets the grease."]
["do not count your chickens before they hatch.",null,"Do not count your chickens before they hatch."]
["a picture is worth a thousand words.",null,"A picture is worth a thousand words."]
["keep your friends close, but your enemies closer.",null,"Keep your friends close, but your enemies closer."]
["nothing is certain except for death and taxes.",null,"Nothing is certain except for death and taxes."]
["houston, we have a problem.",null,"Houston, we have a problem."]

{"sheet":"Uppercase to sentence case","index":2,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel formula to change all caps to sentence case"]
["Source data",null,"Sentence case"]
["THE CELL CONTAINS JUST 1 SENTENCE.",null,{"$f":"UPPER(LEFT(A3:A25, 1)) & LOWER(MID(A3:A25, 2, LEN(A3:A25)-1))","v":"The cell contains just 1 sentence."}]
["THE CELL DOES NOT CONTAIN ANY PROPER NOUNS.",null,"The cell does not contain any proper nouns."]
["THE CELL DOES NOT CONTAIN ANY ABBREVIATIONS.",null,"The cell does not contain any abbreviations."]
["BETTER LATE THAN NEVER.",null,"Better late than never."]
["ACTIONS SPEAK LOUDER THAN WORDS.",null,"Actions speak louder than words."]
["PRACTICE MAKES PERFECT.",null,"Practice makes perfect."]
["WHEN IN ROME DO AS THE ROMANS DO.",null,"When in rome do as the romans do."]
["FORTUNE FAVORS THE BOLD.",null,"Fortune favors the bold."]
["HONESTY IS THE BEST POLICY.",null,"Honesty is the best policy."]
["THE PEN IS MIGHTIER THAN THE SWORD.",null,"The pen is mightier than the sword."]
["KNOWLEDGE IS POWER.",null,"Knowledge is power."]
["ELEMENTARY, MY DEAR WATSON.",null,"Elementary, my dear watson."]
["NECESSITY IS THE MOTHER OF INVENTION.",null,"Necessity is the mother of invention."]
["BEAUTY IS IN THE EYE OF THE BEHOLDER.",null,"Beauty is in the eye of the beholder."]
["THE GRASS IS ALWAYS GREENER ON THE OTHER SIDE.",null,"The grass is always greener on the other side."]
["YOU REAP WHAT YOU SOW.",null,"You reap what you sow."]
["TWO WRONGS DO NOT MAKE A RIGHT.",null,"Two wrongs do not make a right."]
["THE SQUEAKY WHEEL GETS THE GREASE.",null,"The squeaky wheel gets the grease."]
["DO NOT COUNT YOUR CHICKENS BEFORE THEY HATCH.",null,"Do not count your chickens before they hatch."]
["A PICTURE IS WORTH A THOUSAND WORDS.",null,"A picture is worth a thousand words."]
["KEEP YOUR FRIENDS CLOSE, BUT YOUR ENEMIES CLOSER.",null,"Keep your friends close, but your enemies closer."]
["NOTHING IS CERTAIN EXCEPT FOR DEATH AND TAXES.",null,"Nothing is certain except for death and taxes."]
["HOUSTON, WE HAVE A PROBLEM.",null,"Houston, we have a problem."]

{"sheet":"Change text to sentence case","index":3,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel formula to change text to sentence case"]
["Source data",null,"Sentence case"]
["sentence 1. sentence 2? senTENce 3! \nsentence 4.",null,{"$f":"_xlfn.REGEXREPLACE(LOWER(A3:A18),\"([?!.]+\\s+|^)([a-z])\",\"$1\\u$2\")","v":"Sentence 1. Sentence 2? Sentence 3! \nSentence 4."}]
["life is like RIDING a bicycle. to keep your balance, you must keep moving.",null,"Life is like riding a bicycle. To keep your balance, you must keep moving."]
["the only thing we HAVE to fear is fear itself. courage will carry you through.",null,"The only thing we have to fear is fear itself. Courage will carry you through."]
["why do we fall? so we can learn to pick ourselves up! failure is part of success.",null,"Why do we fall? So we can learn to pick ourselves up! Failure is part of success."]
["do what you can with what you have. where you are is enough to start.",null,"Do what you can with what you have. Where you are is enough to start."]
["IF YOU WANT SOMETHING SAID, ASK A MAN. IF YOU WANT SOMETHING DONE, ASK A WOMAN.",null,"If you want something said, ask a man. If you want something done, ask a woman."]
["happiness depends upon ourselves. it comes from within, not from outside.",null,"Happiness depends upon ourselves. It comes from within, not from outside."]
["knowledge speaKS, but wisdom listens. understanding takes TIME and patience.",null,"Knowledge speaks, but wisdom listens. Understanding takes time and patience."]
["the journey matters more than the destination. enjoy each step along the way.",null,"The journey matters more than the destination. Enjoy each step along the way."]
["WHAT WE THINK, WE BECOME. OUR THOUGHTS SHAPE OUR REALITY.",null,"What we think, we become. Our thoughts shape our reality."]
["dream big and dare to fail. great things never come from comfort zones.",null,"Dream big and dare to fail. Great things never come from comfort zones."]
["LIFE is liKE a box oF chocolates. you never know WHAT you’re gonna get. ",null,"Life is like a box of chocolates. You never know what you’re gonna get. "]
["believe you can and you're halfway THERE. confidence is a powerful start.",null,"Believe you can and you're halfway there. Confidence is a powerful start."]
["keep your face always toward the sunshine. shadows will fall behind you.",null,"Keep your face always toward the sunshine. Shadows will fall behind you."]
["YOU MISS ONE HUNDRED PERCENT OF THE SHOTS YOU DO NOT TAKE.",null,"You miss one hundred percent of the shots you do not take."]
["the best way to predict the future is to create it. take action today.",null,"The best way to predict the future is to create it. Take action today."]
[]
[]
[]
[]
[]
[]
[]
["Dd"]
[]
["Ff"]
[]
["Ss"]

{"sheet":"Sentence case VBA","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Convert text to sentence case in Excel with VBA"]
["Sample data",null,"How to use the macro:"]
["sentence 1. sentence 2? senTENCE3! Sentence 4.",null,"1. Select the range A3:A18."]
["life is like RIDING a bicycle. to keep your balance, you must keep moving.",null,"2. Press Alt + F8 to open the Macro dialog box."]
["the only thing we have to fear is fear itself. courage will carry you through.",null,"3. Select the SentenceCase macro and click Run."]
["why do we fall? so we can learn to pick ourselves up! failure is part of success."]
["do what you can with what you have. where you are is enough to start."]
["if you want something said, ask a man. if you want something done, ask a woman."]
["happiness depends upon ourselves. it comes from within, not from outside."]
["knowledge speaks, but wisdom listens. understanding takes time and patience."]
["the journey matters more than the destination. enjoy each step along the way."]
["what we think, we become. our thoughts shape our reality."]
["dream big and dare to fail. great things never come from comfort zones."]
["life is like a box of chocolates. you never know what you’re gonna get. "]
["believe you can and you're halfway there. confidence is a powerful start."]
["keep your face always toward the sunshine. shadows will fall behind you."]
["you miss one hundred percent of the shots you do not take."]
["the best way to predict the future is to create it. take action today."]