HOW DO I REPLACE COMMAS WITH LINE BREAKS IN EXCEL?

Copper Contributor

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 + ENTER in the Replace input but it hasn't been working. I am on a mac. Please help.

3 Replies

@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!

Screenshot 2022-03-09 at 05.38.33.png

@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.