Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Searching for a new line character.
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 |
#2
|
|||
|
|||
If you have got a newline, its CHAR() is 10.
Have a good day. -- Gary''s Student "Michael" wrote: 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 |
#3
|
|||
|
|||
Great! Thank you!
"Gary''s Student" wrote: If you have got a newline, its CHAR() is 10. Have a good day. -- Gary''s Student "Michael" wrote: 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 |
#4
|
|||
|
|||
And one way to see if there's an alt-enter in A1:
=IF(COUNTIF(A1,"*"&CHAR(10)&"*")0,"yep","nope") Michael wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
Macro - Skipping a line | Excel Worksheet Functions |