Autocomplete Location/Address Entry Component

[Robert_Petitto]

only way I’ve seen this is here:

Filter visibility by Character Count!

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…