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 ...
minnd447
Mar 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_Eekelen
Mar 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.