How to Convert Text to Lowercase Snake Case in Google Sheets
Learn how to convert text to lowercase snake case in Google Sheets using a simple formula that combines the LOWER and SUBSTITUTE functions.
So we want to convert any text we have in the A column to snake case in the B column. That means it's going to be lowercase and have an underscore wherever there is a space. So how do we do this? First we will use lower. We will select the cell we want to use and wrap it with lower. This converts it to a lowercase. Then we will wrap this with substitute. And the text we're going to search is the output of this lower. What we're going to search for after we add a comma is a space. And what we'll replace it with in quotes is an underscore. And that converts text to snake case in a single formula .