+ Reply to Thread
Results 1 to 2 of 2

Formatted column text to HTML - Is it possible?

  1. 08-05-2016, 02:40 PM #1
    mpoker84
    mpoker84 is offline
    Registered User
    Join Date
    08-05-2016
    Location
    London
    MS-Off Ver
    Office 2013
    Posts
    1

    Formatted column text to HTML - Is it possible?

    I've got a spreadsheet with over 2,000 lines in. One of the columns contains a long text description with paragraphs, bullets and other basic formatting.

    If there a way I can format this in basic html?

    i've been using wordtohtml.net to manually copy and paste lines via the web that out put the code original text in html but as you can imagine its a pain with so many lines.
    I've looked around and all I can seem to find is functions to convert tables of worksheets to HTML but not specific cells.

    If anyone has any ideas they will be very welcomed.

    Thanks
    Mark

    Attached is a screen shot of the before and after outputs from the website mentioned

    conversion text.PNG
    Reply With QuoteRegister To Reply
  2. 08-09-2016, 04:37 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Formatted column text to HTML - Is it possible?

    If you can provide a sample workbook with enough information for proof of concept it would help. What will also help is if you can provide a before and after as well. This site has an issue that many members can't see PNG files.

    I'm assuming you want an Excel input and a text file output?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IE object how to loop through a formatted HTML?
    By soranz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2015, 06:12 AM
  2. Convert formatted text to html code
    By merQrey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2015, 11:12 AM
  3. Format Cell to display HTML code as formatted text
    By needhelp1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 05:56 PM
  4. [SOLVED] Convert a column of mixed formats to a column that is all text formatted for sorting
    By mrp in forum Excel General
    Replies: 4
    Last Post: 08-25-2012, 07:49 AM
  5. convert formated excel column to html source text with html tags
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2011, 04:22 PM
  6. Pasting HTML formatted text as plain text in Excel
    By JeffCutter in forum Excel General
    Replies: 1
    Last Post: 09-21-2007, 07:43 AM
  7. Converting formatted text into HTML tags
    By cammo in forum Excel General
    Replies: 0
    Last Post: 12-01-2005, 02:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1