Forum Discussion
minnd447
Mar 09, 2022Copper Contributor
HOW DO I REPLACE COMMAS WITH LINE BREAKS IN EXCEL?
Hello, I have a list of linkedin links that are only separated by commas. I want to use find and replace to turn these comma into line breaks, but excel won't let me. I've tried CTRL + J and ALT ...
Riny_van_Eekelen
Mar 09, 2022Platinum Contributor
minnd447 The Find&Replace trick indeed doesn't work. You need the SUBSTITUTE function to swap comma's for CHAR(10), which is the character code for a line break. Don't forget to format the cell to Wrap Text!
- minnd447Mar 09, 2022Copper Contributor
Riny_van_Eekelen Thanks, but even in this format, my links are un-clickable, and the amount of line-breaks is limited.
- Riny_van_EekelenMar 09, 2022Platinum Contributor
minnd447 You didn't mention that the links needed to be clickable. If that's the case you need to split the links into separate cells. You can use Text -to-columns for that. On the Data ribbon in the Data Tools group.