Finding the @ character within a text, cell range

Closed
Jaye - Aug 31, 2016 at 12:03 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Sep 1, 2016 at 11:19 AM
Hello,

I can't seem to find anything that's specific to what I'm looking for.

I'm trying to find a formula that will tell me the following:

1. Whether the character '@' exists within cell range A1 or A2 or both.
2. IF YES, return result 1, 2 or Both.

COLUMN A | COLUMN B
***@*** | xxxxxx

Appreciate the assistance.

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Sep 1, 2016 at 11:19 AM
Hi Jaye,

Try this:
=IF(ISERROR(FIND("@",A1)),"",1& " " ) & IF(ISERROR(FIND("@",A2)),"",2)

Best regards,
Trowa
0