Upload a Carriage Return / New Line of Text during Product CSV Import

GrapenutsWineGrapenutsWine Member Posts: 1

Hi,

I am trying to import a csv that has a new line in the product description. I have 1000+ products to edit, and need to use find and replace function within Excel. For example:


I currently have "100% Pinot Noir - California" in cell c2, and need to replace the " - " on the 1000+ products within the csv to return the following:

100% Pinot Noir

California


Lightspeed import won't recognize a carriage return, I've tried using quotes, can't figure out any solution.


Any ideas?

Sign In or Register to comment.