Go Back   3dCart Shopping Cart Software Forums > Shopping Cart Software > General Configuration Questions

Reply
 
Thread Tools Display Modes
  #1 ()  
Old 12-06-2007, 11:20 PM
kernphilip kernphilip is offline
3dCart Newbie
 
Join Date: Oct 2007
Posts: 24
Default Formating excel to csv

I think a similar issue was raised earlier but I can't find a solution so I will pose it again. I have an excel spreadsheet full of product descriptions. I've attached an excel file so you can see what I am working with.

When I turn this into a csv I loose all of the extended description formating. How can I import this data without having in run into one long string?

I've tried replacing every "*" with "<br>" but it replaces the entire contents of the cell rather than just the "*". Any guidance would be appreciated.
Attached Files
File Type: zip product_sample.zip (52.1 KB, 4 views)
__________________
http://www.prosoundsupplies.com
Reply With Quote
  #2 ()  
Old 12-07-2007, 07:44 PM
RobertFranz RobertFranz is offline
3dCart Newbie
 
Join Date: Nov 2007
Posts: 11
Default

It looks fine to me.

Are you changing the cell formating on your extended description column to Wrap Text?

That was the only change I made, and afaik, that's only a display setting.
After that I saved it as a csv and it was fine.

Mind you, I'm shooting from the hip here, and may completely misunderstand your question.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 10:15 PM.


Powered by vBulletin® Version 3.6.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8