Forum Discussion
Need to convert from 3 lines to 1 line with delimiter
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.
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.
Hi Hans,
Thank you so much for your help. it is working as expected.
Thank you so much for your help. it is working as expected.