Searching for a new line character.

G

Guest

Hey guys!

I was wondering if you could help me. I am trying to compare two lists of
numbers to one another and check for anomalies. I can only use excel
functions (no VB scripts :-( ).

I already wrote functions that will examine the data and mark whether the
data has leading zeroes, alpha characters, dashes, etc. However, I am having
difficulty finding a way to check and see if there is a newline character in
the data. Like when someone hit alt+enter to insert a newline in a cell.

How would you use the search function to find it? Or what is the ANSI
character code for a newline char?

I greatly appreciate any assistance you could offer.

Thanks,

-Michael
 
D

Dave Peterson

And one way to see if there's an alt-enter in A1:
=IF(COUNTIF(A1,"*"&CHAR(10)&"*")>0,"yep","nope")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for either a character or no character 3
Searching for anything BUT a particular character 5
Searching UPWARDS for a value? 3
The SEARCH function and parsing data 2
Problem with the VALUE function 9
Is there a way to prevent Character to Number conversion 1
Leading zeroes, text/numbers, import/export 2
Query AS400 and unknown character 6

Top