Dear Excel Community,
Currently I have multiple cells with data arranged like the example below:
<tbody>
Apple
Orange
Watermelon & Mangosteen
Using this formula :
For Each UsedCell In Selection
Cells.Replace What:=Chr(10), Replacement:=" "
My data gets rearranged to...