sweetmetrics
New Member
- Joined
- Apr 29, 2011
- Messages
- 22
What I have:
I have a .csv file that has a column that contains 4 paragraphs of text within each cell. When "wrap text" is selected, an individual cell appears neatly formatted. I have roughly 300 rows of these paragraphs (300R x1C)
What I am trying to do:
Remove paragraphs 2 & 4 while preserving the 'formatting' so the new cell has just paragraphs 1 & 3. I need it this way because I am uploading this .csv file back into an e-commerce store database. These sets of paragraphs are actually product descriptions of products for sale on a website.
What I've tried:
Text-to-Columns-> Delimiter=paragraph -> delete the un-needed cells then concatenate back together. Unfortunately I have failed.
I haven't been able to properly separate the cells. I also am not sure how I would concatenate them back together properly either.
Thank you in advance for your help!
I am using Excel for Mac (2011) with a .csv output file required.
I have a .csv file that has a column that contains 4 paragraphs of text within each cell. When "wrap text" is selected, an individual cell appears neatly formatted. I have roughly 300 rows of these paragraphs (300R x1C)
What I am trying to do:
Remove paragraphs 2 & 4 while preserving the 'formatting' so the new cell has just paragraphs 1 & 3. I need it this way because I am uploading this .csv file back into an e-commerce store database. These sets of paragraphs are actually product descriptions of products for sale on a website.
What I've tried:
Text-to-Columns-> Delimiter=paragraph -> delete the un-needed cells then concatenate back together. Unfortunately I have failed.

Thank you in advance for your help!

I am using Excel for Mac (2011) with a .csv output file required.