Converting text to lowerCamelCase in Google Sheets

Other Questions Google Sheets
1

Hey everyone! I’m trying to figure out how to make a function in Google Sheets that changes text with spaces into lowerCamelCase. For example, I want to turn ‘hello world example’ into ‘helloWorldExample’.

I’ve seen some stuff about regular CamelCase, but I’m not sure how to make it work for lowerCamelCase. Does anyone have any ideas or tricks they’ve used before? I’m not great with formulas, so any help would be awesome!

Here’s a simple example of what I’m trying to do:

function toLowerCamelCase(input) {
  // Need help here!
  return output;
}

// Should return 'helloWorldExample'
toLowerCamelCase('hello world example');

Thanks in advance for any suggestions!

2

I’ve tackled this problem before in Google Sheets. Here’s a custom function that should do the trick:

function toLowerCamelCase(input) {
  var words = input.toLowerCase().split(' ');
  var result = words[0];
  for (var i = 1; i < words.length; i++) {
    result += words[i].charAt(0).toUpperCase() + words[i].slice(1);
  }
  return result;
}

This function first converts the input to lowercase and splits it into words. It keeps the first word as-is, then capitalizes the first letter of each subsequent word and adds it to the result. You can use this in your spreadsheet by calling =toLowerCamelCase(A1) where A1 contains your input text. Hope this helps!

3

I’ve had to deal with this exact issue in my work projects. Here’s a nifty trick I discovered that might save you some time:

Instead of writing a complex function, you can use a combination of built-in Google Sheets formulas. Try this formula:

=LOWER(LEFT(A1,1))&REGEXREPLACE(PROPER(A1),“\s”,“”)

Here’s how it works:
LOWER(LEFT(A1,1)) keeps the first letter lowercase.
PROPER(A1) capitalizes the first letter of each word.
REGEXREPLACE removes all spaces.

Just pop this into a cell next to your original text, and it’ll automatically convert it to lowerCamelCase. It’s been a real time-saver for me, especially when dealing with large datasets. No custom functions needed!

4

yo, i got a quick fix for ya! try this formula:

=LOWER(LEFT(A1,1))&REGEXREPLACE(PROPER(SUBSTITUTE(A1," “,”“)),”“,”")

it’s pretty sweet. just chuck ur text in A1 and boom, lowerCamelCase magic happens. no need for fancy scripts or nuthin. lemme know if it works for ya!