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.

Related:

1 response

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

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

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

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

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

1 response