Concatenate & Capitalize formula

Create a custom formula in Google Sheets that concatenates and capitalizes text:

1. Open your Google Sheet and navigate to the tab where you want to add the custom formula.
2. Click on the “Tools” menu and select “Script editor”.
3. In the script editor, paste the following code:

function CONCAT_CAPS(string1, string2) {
  return string1.toUpperCase() + " " + string2.toUpperCase();
}

4. Save the script by clicking on “File” and then “Save”.
5. Go back to your Google Sheet and enter the following formula in a cell where you want to use the custom formula:

=CONCAT_CAPS(A1,B1)

Note: Here, A1 and B1 are the cells that contain the text you want to concatenate and capitalize.

6. Hit enter, and the formula will return the concatenated and capitalized text.

For example, let’s say you have the following data in cells A1 and B1:

A1: hello
B1: world

When you use the custom formula in cell C1, the formula will return:

C1: HELLO WORLD

This custom formula can be used to easily concatenate and capitalize text in Google Sheets without having to format the text manually.