# Convert All Rows in a particular column in CAPS

**URL:** https://community.glideapps.com/t/convert-all-rows-in-a-particular-column-in-caps/24751
**Category:** Ask for Help
**Created:** [March 26, 2021, 9:44am UTC](https://community.glideapps.com/t/convert-all-rows-in-a-particular-column-in-caps/24751 "2021-03-26T09:44:28Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 26, 2021, 11:46am UTC](https://community.glideapps.com/t/convert-all-rows-in-a-particular-column-in-caps/24751/6 "2021-03-26T11:46:39Z")

</div>

What @Darren_Murphy suggested, was just to set the template to point to your first column. Then add a replacement for each letter of the alphabet. The problem here is that Glide requires an existing column as a replacement value. I think the only way to make this work purely in Glide, at the moment, would be to create a template column for each letter of the alphabet. Then create a final template column that points to the Name column, then have a replacement set up for each letter of the alphabet.

So it would be 26 template columns for each capital letter, and 1 template column to build the the final NAME column.

Not a good solution. Two things we need from Glide:

- The ability to use Custom Values as replacements in a Template column (This would have allowed for a one column solution to your problem, but still ugly with 26 replacement values)
- Good string manipulation functions, such as Substring, Trim, Pad, Upper, Lower, Proper, etc.

Add you vote to this request.

> [@Add Text Functions to Template columns, similar to Math calculations](https://community.glideapps.com/t/add-text-functions-to-template-columns-similar-to-math-calculations/23298):
>
> I would really like to see the ability to do basic text operations in the Template column, the way we can now do math ones in the Math column. For example, emails are notoriously ambiguous when it comes to casing so I could create a “Lowercase Email” Template column with string “LOWER(email)” and a replacement for “email” instead of doing this in the Google Sheet which has been very slow to update lately. Another example, I could find duplicate users using different emails (work & personal) us…

---

_[View the full topic](https://community.glideapps.com/t/convert-all-rows-in-a-particular-column-in-caps/24751)._