+ Reply to Thread
Results 1 to 6 of 6

pulling words like SITTELLA and SITELLA

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    pulling words like SITTELLA and SITELLA

    Attached file has two types of words 7 and 8 on a and c

    I have pulled expected results on g and H , those numbers its probability quoted on c and d of each word

    I want the macro to find such pattern

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    Re: pulling words like SITTELLA and SITELLA

    Since the file is big enough , attaching twice , sevens should go on column a and eights on column b when you merge

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    Re: pulling words like SITTELLA and SITELLA

    Attached as one file , deleted many words , have kept the first 10,000 rows of each
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    Re: pulling words like SITTELLA and SITELLA

    required macro , i don't think a formula can handle this

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,197

    Re: pulling words like SITTELLA and SITELLA

    What have you tried so far?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: pulling words like SITTELLA and SITELLA

    Not clear about what you need. Does this help any?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pulling out the first 3 words
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2015, 06:50 AM
  2. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  3. Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  4. Replies: 2
    Last Post: 07-02-2013, 11:35 AM
  5. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  6. Replies: 3
    Last Post: 11-28-2012, 04:00 AM
  7. Replies: 1
    Last Post: 04-04-2012, 07:15 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