# Did you know this googlesheet bug?

**URL:** https://community.glideapps.com/t/did-you-know-this-googlesheet-bug/13300
**Category:** Ask for Help
**Created:** [July 30, 2020, 8:12am UTC](https://community.glideapps.com/t/did-you-know-this-googlesheet-bug/13300 "2020-07-30T08:12:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)
#### Post date: [July 30, 2020, 8:12am UTC](https://community.glideapps.com/t/did-you-know-this-googlesheet-bug/13300/1 "2020-07-30T08:12:42Z")

</div>

if you try this formula over this value “gio@condo.it(+)7i9ik.mLRJO2RysGx0eR0g(!)7302020”:

=iferror(mid(indirect(“A”&row()),search(“(!)”,indirect(“A”&row()))+3,8),“Not Found”)  
It works!

but if you try in this way over this value “gio@condo.it(+)7i9ik.mLRJO2RysGx0eR0g(_)7302020":  
=iferror(mid(indirect(“A”&row()),search("(_)”,indirect(“A”&row()))+3,8),“Not Found”)

then it doesnt work! actually instead to intercept the STAR (\*) it intercept the PLUS (+). 🤨

PS: the second string it is like this gio@condo.it(+)7i9ik.mLRJO2RysGx0eR0g( \* )7302020 but without spaces, here the comment box doesn’t show it