Searching for a carriage return

[lwilt]

Im trying to search through an excel find to find all of the carriage returns in a field.

ex:
HARRY S TRUMAN NATIONAL HSTRC SITEû223 N MAIN ST

I need to have each line item with a carriage return marked so that I can have them fixed in my database. So how could I create a function or just using control find to go through the file to find each line item with a carriage return and mark it so I can fix those later?

 

[Luke M]

You can Find a carriage return by hitting Ctrl+J in the "Find" field of the Find & replace.
http://datapigtechnologies.com/blog/index.php/find-and-replace-carriage-returns/

If you want to select them all, perform a Find, hit the Final All button, select one of the cells in drop down list that appears, then hit Ctrl+A (to select all Found records). You can this format the selected cells however you want.

 

[lwilt]

I tried Ctrl+J and it didn't work

 

[Luke M]

Can you elaborate?
"It didn't work" meaning....

• Nothing happened
• The Find didn't find anything
• The cursor disappeared
• Excel crashed

 

[lwilt]

It didn't find anything.

I'm not sure if û is a carriage return but I thought it was.

 

[Luke M]

I don't think so...can you perhaps just copy the û into the Find field, and search that way?

 

[bobhc]

You could use conditional formatting for this (in the example, I selected A10:B10 and went Conditional Formatting. If you do not want to do a test in the cells I selected then just select your data.
Having selected A10:B10 and gone Conditional Formatting: New rule and select the apply CF with formula (bottom on of the formula rules) you only need to enter the following formula and then select your desired format (the cells in A1:B6 will have the right formula applied to them)

=COUNTIF(1:1,"*"&CHAR(10)&"*")>0


.


.