+ Reply to Thread
Results 1 to 4 of 4

add html to spreadsheet

  1. #1
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    add html to spreadsheet

    I want to add this code to one excel row -

    <form action="http://endangeredspecies.com/shopsite_sc/sc/order.cgi" method=post>
    <BR><input type=hidden name="storeid" value="*166a319dd528707907b6a31f9c">
    <input type=hidden name="dbname" value="products">
    <input type=hidden name="function" value="add">
    <input type=hidden name="itemnum" value="4733">
    <input type=image src="http://endangeredspecies.com/shopsite_sc/media/add_to_cart.gif" alt="add_to_cart.gif" width="83" height="20" hspace="3" vspace="3" border="0" align="bottom" name="Add to Cart">
    <input type=image src="http://endangeredspecies.com/shopsite_sc/media/view_cart.gif" alt="view_cart.gif" width="71" height="20" hspace="3" vspace="3" border="0" align="bottom" name="View Cart">
    </form>

    but it insists in adding it on numerous separate rows.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: add html to spreadsheet

    You don't say how you are currently trying to add it.

    Excel will use the embedded CR/LF to place text into the next row.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: add html to spreadsheet

    I just pasted into one cell using control V, after having saved it using control C

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: add html to spreadsheet

    do CTRL+C
    goto the cell where you want to paste the html text
    F2 to edit cell
    CTRL+V to paste into single cell

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1