# 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:** 4

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 26, 2021, 10:42am UTC](https://community.glideapps.com/t/convert-all-rows-in-a-particular-column-in-caps/24751/4 "2021-03-26T10:42:20Z")

</div>

hmm, I may have been a bit hasty there. When I responded I was thinking of this 🔽

> [@Filter visibility by Character Count!](https://community.glideapps.com/t/filter-visibility-by-character-count/20867/4):
>
> I think I got something here. Not the cleanest solution, but not too bad either. Just takes a little math. Here you can see that column 11 has two rows with text in it. New Column L has a template with the value of 1 in it. New Column J is a template that replaces every letter (and space if you choose) with the number ‘1’. You shouldn’t need to replace any numbers as they are already numbers, but you will probably have to include every letter of the alphabet along with any symbols you would…

But, maybe not…  
This is yet _another_ example of something that would be trivial with some string manipulation functions.  
And of course it’s also trivial with a spreadsheet function.  
But in the GDE with the tools we currently have…  
I’ll have a play…

---

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