Formula to find if there is a carrier return in a cell

[STIRRELL]

Hi,
We have a column of emails for employees. Is there a formula to identify if there is a carrier return in the data? Say the email addresses are in column A. I tried to look for a formula but I had no luck.Sorry we are looking for a return of YES in column B if there is a carrier return else NO..
Thanks all,
Sharon

 

[Eric W]

Try:

Book1
	A	B
1	List
2	abc@def	No
3	def@ghi, jkl@mno	Yes
Sheet15

Cell Formulas
Range	Formula
B2:B3	B2	=IF(ISNUMBER(FIND(CHAR(10),A2)),"Yes","No")

 

[STIRRELL]

Thank you I will give that a go. thank you so much