Results 1 to 5 of 5

Move Cells Containing Specific Text

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Move Cells Containing Specific Text

    Hi there,

    I have an Excel sheet with several columns of data, each containing the link to a website. To the far right of this data, I have a column called "Official Source" in which I'd like to copy over any website links containing the phrase "sec.gov" (if there are any, if not than leave the cell blank).

    For example, if I have the following data in my sheet:

    Column A Column B Column C
    www.wsj.com www.nytimes.com sec.gov/Ar


    Than I would want the last source to move to column D -

    Column A Column B Column C Column D
    www.wsj.com www.nytimes.com sec.gov/Ar


    Any ideas how to do this?
    Last edited by financeanalyst; 04-09-2014 at 03:03 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clear contents of specific cells on the same row if a specific cell on that row is empty
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2014, 01:48 PM
  2. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  3. Copy and insert rows with contents and format based on specific number
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-13-2012, 03:38 AM
  4. Clear contents of cells that do not contain specific text, sort cells that do
    By feckless.lout in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2010, 01:41 AM
  5. Delete specific cells contents in a row with some locked cells in the same row
    By trussman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2005, 03:06 PM

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