Remove line breaks from cells

[shre0047]

I have a few columns (~75000 rows) where I've extracted data and included HTML tags. I've removed the tags, but now there are line breaks I'm hoping I can eliminate via VBA or formula.

Column I (Current)	Column J (Final state)
, , Navigate to the Instructions section in page , ,	Navigate to the Instructions section in page
, , Click on the drop down and select option , ,	Click on the drop down and select option
, , Spinning wheel appears and once loading is complete ensure user can see the products that were available in cart , sorted by their associated ID , ,	Spinning wheel appears and once loading is complete ensure user can see the products that were available in cart sorted by their associated ID
, , Validate each order line , number displays a PO , Line number Text ID , ,	Validate each order line number displays a PO Line number Text ID
, , Enter number in the , Number field. Update Created on , date and press execute , ,	Enter number in the Number field. Update Created on date and press execute

 

[Momentman]

If you are sure of the Character for example, Assuming it is character 10

1. You could use FIND and REPLACE and in the find type ALT+0010(using the numeric keypad) and replace with nothing. That should rid you of the LF character
2.

SUBSTITUTE(A1, CHAR(10),""

 

[shre0047]

I did use this via a macro and formula, but it doesn't remove my line breaks and aligns to what I currently have in Column I

 

[MARK858]

Referencing a cell where you have a line break before your text what does

=CODE(A1)

give you?
You might also try ALT + 010 in the Find/Replace (make sure in the Options that you don't have "Match entire cell contents" checked).

 

[eduzs]

Really is line breaks? Maybe be vertical alignment.
Line breaks can be chr(10), chr(11) or chr(13).