Forum Discussion
Need help removing wrap text from 3 cells, not as easy as it sounds
You may try something like this and see if that resolves the issue.
In a blank column, in Row2, place this formula...
=TRIM(SUBSTITUTE(B2,CHAR(10)," "))
and then copy it down to row4.
Then copy the three formula cells, select the cell B2 and paste it as Values only and delete the formula cells. That should replace all the line breaks in B2:B4 with space and trim them in the end to remove any leading or trailing spaces.
You may try something like this and see if that resolves the issue.
In a blank column, in Row2, place this formula...
=TRIM(SUBSTITUTE(B2,CHAR(10)," "))
and then copy it down to row4.
Then copy the three formula cells, select the cell B2 and paste it as Values only and delete the formula cells. That should replace all the line breaks in B2:B4 with space and trim them in the end to remove any leading or trailing spaces.
You're welcome! Glad it worked as desired.