Magento

I’ve been reading through these posts on how to import my images (about 1000) because I’ve been having issues.

The Reason:  When I created my .csv, I had to use a concatenation to populate all of the image fields.  When I was importing, Magento was reading the concatenation value and not the name of the file value [(=CONCATENATION("/”,+SKU,".jpg") instead of /xxx.jpg.].

So, does anyone know how to clear the contents of a field in excel to remove the formulae while leaving the contents?

I don’t.

duh, “paste special”

sometimes you have to have a conversation with yourself.