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 + 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!
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.
