Converting plain text to HTML within an Excel spreadsheet.

[rachste]

I designed a new layout for a company that wants to switch from MIVA 4 to MIVA 5. There's a problem we need to address before switching over: converting plain text to HTML within an Excel spreadsheet.

We have Excel spreadsheets for each brand that we're selling. In these spreadsheets are descriptions for each product, but they're not formatted in HTML. It would be fantastic if someone has the capability of wrapping each linebreak in <p></p>. Relatively simple, but unfortunately we don't have a way to do this in bulk.Any bites? :)

[RichardW]

Re: Converting plain text to HTML within an Excel spreadsheet.

If you don't have a good text editor, you could do it by adding a column before and after the "Description" column and putting the <p> and </p> in. Then copy the spreadsheet into Text Edit(mac) or Notepad (Windows) and do a "Find and Replace". Find the "tab <p>" and replace with just a <p> and then find the "tab </p>" and replace with <p>.
Here is your descriptions with the <p> tags. To import this data, you will have to add a column for the product code and then do a product import.

Hope that helps

[gmanning]

Re: Converting plain text to HTML within an Excel spreadsheet.

You could also put this formula in the next column from Description.

(Assuming description in field B2)

In field C2 put

="<p>" & B2 & "</p>"

Note: this also assumes the description is just one paragraph. I can reply more later with suggestions if you are dealing with multiple paragraph descriptions.

[rachste]

Re: Converting plain text to HTML within an Excel spreadsheet.

Thanks for the replies. :) I'll definitely run them over with my boss.

Note: this also assumes the description is just one paragraph. I can reply more later with suggestions if you are dealing with multiple paragraph descriptions.

What's your suggestion for multiple paragraph descriptions?