Hard return

[Guest]

Does any one out there know how to remove a lot of hard returns from multiple
cells

 

[Gord Dibben]

Usually Edit>Replace works on the selection if the hard return is generate by
Alt + Enter in a cell.

What: CTRL + j

With: nothing

Replace all.

If generated by CHAR(10) in a formula, copy>paste special>values first.


Gord Dibben MS Excel MVP

 

[Rick Rothstein \(MVP - VB\)]

Does any one out there know how to remove a lot of

hard returns from multiple cells

You could run a macro similar to this (change the indicated range as
needed)....

Dim C As Range
For Each C In Range("b1:f3")
C.Value = Replace(C.Value, vbLf, " ")
Next

and then save the worksheet afterwards. The above macro removes each Line
Feed (what you are calling a "hard return") and replaces them with a single
blank space.

Rick

 

[Dave Peterson]

Or replace it with a space character?

(just in case <vbg>)

 

[Gord Dibben]

I just never remember to add that piece of info<g>

Thanks, Gord