Split words by uppercase in Google Sheets

=REGEXREPLACE(B2,"([a-z])([A-Z])","$1,$2")

B2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Split words by uppercase in Google Sheets

How to split words by uppercase in Google Sheets?
Split words by uppercase in Google Sheets

SPLIT WORDS BY UPPERCASE — GOOGLE SHEETS FORMULA AND EXAMPLE

=REGEXREPLACE(B2,"([a-z])([A-Z])","$1,$2")

  • in the above formula highlight comma (,) as separator and you can change to the desired format