How to Convert Text to Uppercase Snake Case in Google Sheets
Learn how to convert any text in Google Sheets to uppercase snake case by replacing spaces with underscores using the upper and substitute functions.
So in this video, I'm going to show you how to convert any text in a cell to upper snake case. This is different than lower snake case because we want all of our text to be uppercase, but we also want to replace all of the spaces with underscores. First, we're going to add an equal sign and we're going to use upper. This formula takes any sentence we have or any text and converts it to uppercase. Then we're going to wrap upper with substitute. Substitute allows us to take any text we have, we search for a character and replace it with that character or phrase. What we're going to search for is a space and what we're going to replace it with is an underscore. And there we go, we have our text has been converted to snake case. Turn Titles Into Lower Case Hyphened Slugs How Do I Capitalize Each Word in Google Sheets? How to Convert Text to Lowercase Snake Case in Google Sheets