Forum Discussion
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 Thanks, but even in this format, my links are un-clickable, and the amount of line-breaks is limited.
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.