Hello,
I have many cells where data is broken up into many lines; some of those lines are blank. Is there a VB function or formula to remove blank line breaks in Excel cells, or all line breaks?
Many thanks!
views:
212answers:
2
+1
A:
Substitute in a cell for linefeed seems to work - =Substitute(A1, CHAR(10), "")
Jacob G
2010-02-23 19:42:55
It is possible that Char(13) (ie return) is included as well as line feed. The usual order is Char(13)+Char(10) but vice versa is possible.
Remou
2010-02-24 11:20:58
A:
There is a detailed tutorial on the subject called Excel VBA: How To Delete Rows, by Colin Legg that should cover all the areas for you.
Hope it helps...
Mike Rosenblum
2010-02-23 20:14:11