How to replace "\n\n" to "\n" from Google Sheet. Find and replace "Double line-breakers" to only "one line breaker". 구글시트에서 '줄바꾸기' 치환하기

Have you been searching for how to use RegEx in 'Replace with' field?  Don't bother. I realized it's not a supported feature yet unfortunately. (but... really, Google?) 

Anyway, here I share some handy way to replace double line breakers to only one!

The magic keyword that you're searching for are the followings :

 

and then BAAM!

 

 

Exactly what i was looking for :)

 

 

Ref. https://stackoverflow.com/questions/7528169/find-replace-commas-with-newline-on-google-spreadsheet#:~:text=you%20insert%20an%20expression%20as,a%20%22new%20line%22%20character.