# Can we Verify Characters?

**URL:** https://community.glideapps.com/t/can-we-verify-characters/8420
**Category:** Ask for Help
**Created:** [May 4, 2020, 6:28am UTC](https://community.glideapps.com/t/can-we-verify-characters/8420 "2020-05-04T06:28:28Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [May 4, 2020, 6:28am UTC](https://community.glideapps.com/t/can-we-verify-characters/8420/1 "2020-05-04T06:28:28Z")

</div>

I was thinking past week if it’s possible to verify characters in entry componentes like:

- Verify if a phone number has 11 characters
- If an email has the @
- If an ID number has the right number of characters

Summing up, if could be possible to count the number of characters in any **entry component**

Edit: I’ve already tried with _Contains_ option, but it didn’t worked.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 4, 2020, 7:51am UTC](https://community.glideapps.com/t/can-we-verify-characters/8420/2 "2020-05-04T07:51:21Z")

</div>

Hi Lucas,

If you are talking about the formulae to do that in the spreadsheet, here’s the way.

- If a phone number has 11 characters, assuming the number is stored in A:

It must be noted that the number should be carefully formatted so that it does not lose the ‘0’ at the start in specific countries.

E.g: A phone number in Vietnam would look like 0123 456 789, when entered into Sheet as number, it will not take the 0 (as it’s not meaningful in a number context). It must be stored as text, or replace the ‘0’ with country’s prefix (in this case +84).

- If an email has the @:

This FIND formula checks if the string in A has the letter “@” and returns its position. If it does not exist, the FIND formula will return a value error, hence the IFERROR to throw a 0 back instead of #VALUE!

- If an ID number has the right number of characters

Same concept with the phone number, replace the number 11 with the desired number for checking.

---

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [May 4, 2020, 8:09am UTC](https://community.glideapps.com/t/can-we-verify-characters/8420/3 "2020-05-04T08:09:07Z")

</div>

Thanks for sharing @ThinhDinh

But actually I was thinking if it’s possible to do using only glide features

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 4, 2020, 8:20am UTC](https://community.glideapps.com/t/can-we-verify-characters/8420/4 "2020-05-04T08:20:54Z")

</div>

Oh no problem then, hope someone else comes up with a solution. Have a nice week Lucas!
