Skip to content

Instantly share code, notes, and snippets.

@oiler
Created January 29, 2026 21:25
Show Gist options
  • Select an option

  • Save oiler/182cc94d8fccf9718af756bdac2a6089 to your computer and use it in GitHub Desktop.

Select an option

Save oiler/182cc94d8fccf9718af756bdac2a6089 to your computer and use it in GitHub Desktop.
Google Sheet Formula to convert names to lowercase values with no whitespace
=LOWER(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
$C2,
"-", ""
),
"’", ""
),
"'", ""
),
".", ""
),
",", ""
),
" ", ""
),
"á", "a"
),
"à", "a"
),
"ä", "a"
),
"â", "a"
),
"ã", "a"
),
"é", "e"
),
"è", "e"
),
"ë", "e"
),
"ê", "e"
),
"í", "i"
),
"ì", "i"
),
"ï", "i"
),
"ó", "o"
),
"ö", "o"
),
"ú", "u"
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment