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.
2 Replies
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.
