Dear Excel Community,
Currently I have multiple cells with data arranged like the example below:
<tbody>
</tbody>
Essentially I would like to retain the existing paragraphing format but without the level spaces.
Help appreciated!
Thank you!
Currently I have multiple cells with data arranged like the example below:
Apple Orange Watermelon & Mangosteen Using this formula : For Each UsedCell In Selection Cells.Replace What:=Chr(10), Replacement:=" " My data gets rearranged to: AppleOrangeWatermelon &Mangosteen How can I modify the formula to arrange data in this manner instead. Apple Orange Watermelon & Mangosteen |
<tbody>
</tbody>
Essentially I would like to retain the existing paragraphing format but without the level spaces.
Help appreciated!
Thank you!