Results 1 to 7 of 7

Search cells for a string and when that string exists copy entire cell to another cell

Threaded View

nitro535 Search cells for a string and... 06-04-2015, 03:59 PM
oeldere Re: Search cells for a string... 06-04-2015, 04:03 PM
nitro535 Re: Search cells for a string... 06-04-2015, 06:11 PM
newdoverman Re: Search cells for a string... 06-04-2015, 06:13 PM
nitro535 Re: Search cells for a string... 06-04-2015, 08:25 PM
newdoverman Re: Search cells for a string... 06-05-2015, 08:23 AM
newdoverman Re: Search cells for a string... 06-05-2015, 09:28 AM
  1. #1
    Registered User
    Join Date
    06-04-2015
    Location
    houston, tx
    MS-Off Ver
    2010
    Posts
    3

    Search cells for a string and when that string exists copy entire cell to another cell

    I have a spreadsheet where I need all the data of one type in its own column.
    Currently the data appears randomly in any column.
    The data literally has (D), (B), (A), (L) next to it in each cell like this:

    ColA ColB ColC ColD
    (D)30 (B)10 (L)100 (A)45
    (A)6 (D)21 (B)92 (L)2
    (L)3 (A)64 (B)9 (D)65

    So what I need to do is take all of the contents of each cell and line it up like this within the same row the data is found in like this:

    ColE ColF ColG ColH
    (A)45 (B)10 (D)30 (L)100
    (A)6 (B)92 (D)21 (L)2
    (A)64 (B)9 (D)65 (L)3

    I have tried all sorts of mid, find combinations and I cant get it to work right.

    Thank you in advance for any help!

    Edit to add example file
    http://magicmolder.com/sample.xls
    What I am trying to achieve starts in column O and goes to the right.
    Last edited by nitro535; 06-04-2015 at 04:21 PM. Reason: add example file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search Column A & C for string and copy entire row to new sheet
    By ludsonline in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2014, 02:43 AM
  2. Search a cell for a string that exists in a list of values
    By jefflach in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2013, 11:23 AM
  3. Replies: 7
    Last Post: 01-09-2013, 02:28 PM
  4. Identify if string exists, copy entire row.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-26-2011, 02:57 AM
  5. Search Selected Data for a Text String and replace entire cell with new tex
    By maz003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 02:26 PM

Tags for this Thread

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