Previous Topic Next Topic

Finding the @ character within a text, cell range

Closed
Jaye - Aug 31, 2016 at 12:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response