I've given you the response below yesterday to your post,
re:
http://tinyurl.com/2esbm
--------
Maybe CHAR(10) ?
(carriage return via Alt + Enter)
Assume you want to check range A1:C10 in Sheet1
for cells with carriage return
In a new Sheet2:
Put in A1:
=IF(ISERROR(SEARCH(CHAR(10),Sheet1!A1)),"","Yes")
Copy A1 across to C1, then down to C10
to cover the same range as in Sheet1
A1:C10 in Sheet2 will return "Yes" for corresponding
cells with carriage returns in range A1:C10 in Sheet1