+ Reply to Thread
Results 1 to 6 of 6

Batch editing the contents of a cell

  1. #1
    Registered User
    Join Date
    10-31-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    95

    Batch editing the contents of a cell

    I have a huge spreadsheet that I am building to place about 10,000 products on my online shopping cart. I can create the database in excel and upload it for my entire product line but I have a question about one particular cell.

    Each item has a description then in the cell next to it, there is the html of what I want the description to look like for each product when viewed online. What I want to do, since i already have all of the descriptions from my excel pricing program that I built, is to plug the descriptions into the cell containing the html.

    Column U contains the descriptions. Column V contains the html code.

    Example of what is in column U:
    9"W x 12"D x 30"H

    Example of what is in column V:
    <div style="text-align: center; font-weight: bold; font-family: Garamond;"><span style="font-size: 18pt;">9"W x 12"D x 30"H Wall<br></span></div><br style="font-family: Garamond;"><span style="font-family: Garamond; font-size: 12pt;"></span>

    What I want to do is replace 9"W x 12"D x 30"H Wall, which is the description in column V, with whatever is in column U but leave the rest intact.

    I have used =C8&"-B2" in other parts of the sheet to copy a cell and add -B2 to it. I tried doing the same thing here, but obviously ran into problems.

    Thanks in advance for any suggestions.

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Batch editing the contents of a cell

    I might not be reading this right but you are saying that Column U already contains what is in Column V but then you want to replace what is in Column V with Column U... This is a circular error

    Can you clarify and post a dummy workbook?

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    10-31-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: Batch editing the contents of a cell

    Sorry, column U contains the current descriptions, all of them different. I used 9"W x 12"D x 30"H as an example because it is in U1, but they are all different from U1 to U9999.

    Cell V1 contains <div style="text-align: center; font-weight: bold; font-family: Garamond;"><span style="font-size: 18pt;">9"W x 12"D x 30"H Wall<br></span></div><br style="font-family: Garamond;"><span style="font-family: Garamond; font-size: 12pt;"></span>

    I would like to take the current description that is in U1, U2, U3, etc. and insert it in the appropriate place of V1, V2, V3, etc.

    So U2 contains: 12"W x 12"D x 30"H, therefore V2 should contain: <div style="text-align: center; font-weight: bold; font-family: Garamond;"><span style="font-size: 18pt;">12"W x 12"D x 30"H Wall<br></span></div><br style="font-family: Garamond;"><span style="font-family: Garamond; font-size: 12pt;"></span>

    And so on down the column until every description that is in column U is inserted into the appropriate place of column V
    Last edited by cabinetguy; 07-18-2012 at 10:32 AM.

  4. #4
    Registered User
    Join Date
    10-31-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: Batch editing the contents of a cell

    Below is an example in the workbook. U3 is correct, U4, U5, U6, etc are just copies of U3, but need to have the decriptions from column V inserted in the appropriate place.
    dummy.xlsx

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Batch editing the contents of a cell

    have this somewhere:
    PHP Code: 
    <div style="text-align: center; font-weight: bold; font-family: Garamond;"><span style="font-size: 18pt;">{replaceText}<br></span></div><br style="font-family: Garamond;"><span style="font-family: Garamond; font-size: 12pt;"></span
    Then use (assuming the above is in V1:
    PHP Code: 
    =SUBSTITUTE($V$1,"{replaceText}",U3
    However you'll also need to replace any characters with their html equivelents

  6. #6
    Registered User
    Join Date
    10-31-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: Batch editing the contents of a cell

    Perfect! Thank you very much

+ 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