Results 1 to 6 of 6

Batch editing the contents of a cell

Threaded View

  1. #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.

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