Mar 11 2022 02:42 AM
Team,
We have 3 lines in a single row in the excel column. we need to convert from 3 lines to 1 line with delimiter (, or ;). Could you please advise.
Mar 11 2022 02:53 AM
Select the cells.
Press Ctrl+H to activate the Replace dialog.
Click in the 'Find what' box and press Ctrl+J. This inserts an (invisible) line break.
Click in the 'Replace with' box and enter a comma or semicolon (, or ;).
Click Replace or Replace All.
Mar 11 2022 03:12 AM