Need to convert from 3 lines to 1 line with delimiter

New Contributor

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.

2 Replies

@kumaravelu900 

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.