T
ttribble
Does any one out there know how to remove a lot of hard returns from multiple
cells
cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
R
Rick Rothstein \(MVP - VB\)
Does any one out there know how to remove a lot of
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
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
D
Dave Peterson
Or replace it with a space character?
(just in case <vbg>)
(just in case <vbg>)
G
Gord Dibben
I just never remember to add that piece of info<g>
Thanks, Gord
Thanks, Gord