+ Reply to Thread
Results 1 to 2 of 2

Infomation extraction help.

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    38

    Infomation extraction help.

    help-size-color.xlsx

    i NEED TO EXTRACT INFORMATION FROM EITHER COLUMN A,B OR C TO SHOW THE FOLLOWING IN COLUMN D AND E.

    How can i do this?

    Thanks,
    Lee
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Infomation extraction help.

    Hi Lee

    Most of my time on this was spent trying to re-create your jpg file. In future, I think you will find you get more replies if you attach a sample spreadsheet.

    I have produced what you requested, from your column A only.

    The restriction is that the size must only be 1 or 2 characters long

    Let me know if this works for the rest of the data

    Regards
    Alastair
    Attached Files Attached Files

+ 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