+ Reply to Thread
Results 1 to 11 of 11

What u see is in Column A i, Please give me a formula to extract the Buyer names

  1. #1
    Registered User
    Join Date
    10-12-2019
    Location
    London
    MS-Off Ver
    Excel
    Posts
    9

    What u see is in Column A i, Please give me a formula to extract the Buyer names

    What u see is in Column A, Please give me a formula to extract the Buyer names in Column B without all the other junk.

    Buyer name:
    John Dieero
    hfg
    jgf
    jdg
    jjhgk
    hfg
    j
    dkh
    jgs
    kh
    js
    shgf
    kj
    hjdgh
    kgh
    j
    gdk
    gdhk
    dghj
    dghk
    Buyer name:
    Marc Turner
    fhs
    gsj
    fs
    gj
    gj
    hg
    kgh
    ghk
    hgk
    d
    jgsfj
    fgj
    shgk
    gd
    js
    gfj
    k
    hgsj
    gfj
    Buyer name:
    James Dea
    khgd
    k
    gl
    hjl
    jkd
    ghk
    lj
    hdk
    lj
    h
    kdlh
    kgh
    ld
    skh
    hdh
    skh
    hks
    khhk
    s
    dkhg
    Buyer name:
    Paul Reirt
    kdhg
    khd
    lkhfj
    lkhfj
    jl
    h
    lf
    hjl
    dhk
    hgdk
    lh
    j
    dkgh
    lhj
    kd
    lj
    d
    5:03 AM PST
    kdhg
    Buyer name:
    Joanna Eirop
    hdjg
    kdg
    hkdg
    hkhg
    dk
    ghk
    ghk
    dgh
    khdg
    kgd
    kg
    dk
    hl
    fhj
    ff
    hjl
    12/21/2017
    lj
    jfl
    Buyer name:
    Paul D Johnson
    jfl
    l
    l
    hfjl
    hl
    h
    lj
    fhl
    fhl
    jfh
    lfh
    jlf
    hjlf
    hh
    l
    hfjl
    lhf
    l
    lfjh
    Buyer name:
    Peter green

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,983

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    Please Login or Register  to view this content.
    Try this formula in Cell B2 and down
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    10-12-2019
    Location
    London
    MS-Off Ver
    Excel
    Posts
    9

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    Hi there's more buyer names down the list i need a way to get them all as a list...it doesn't seem to do that

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,654

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    .
    This will give you what you want but will also include the "Buyer Name:" and the Date/Time ...

    Paste in B2 and copy down column :

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-12-2019
    Location
    London
    MS-Off Ver
    Excel
    Posts
    9

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    Oh i see what you mean now! thanks! closest to what i need...
    Last edited by 900pluswin; 10-12-2019 at 05:31 PM.

  6. #6
    Registered User
    Join Date
    10-12-2019
    Location
    London
    MS-Off Ver
    Excel
    Posts
    9

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    if you can please also provide me this formula

    I know that each name the buyer name is always 20 or 21 rows below the other one...it varies between those two values

    what formula i could use for this

  7. #7
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    I ran Popipio's formula in the attached and as you can see, it does provide you with all 7 names. Not sure what your issue is with his formula.
    Attached Files Attached Files
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  8. #8
    Registered User
    Join Date
    10-12-2019
    Location
    London
    MS-Off Ver
    Excel
    Posts
    9

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    the issue with that formula is that its kind of a game with the number of letters in each column or something but that won't work for me always

    if you can please also provide me this formula

    I know that each name the buyer name is always 20 or 21 rows below the other one...it varies between those two values

    what formula i could use for this

  9. #9
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    I don't believe that post #2 has anything to do with the string length in a cell.

  10. #10
    Registered User
    Join Date
    10-12-2019
    Location
    London
    MS-Off Ver
    Excel
    Posts
    9

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    damn i'm sorry, all good

    thanks guys!

  11. #11
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: What u see is in Column A i, Please give me a formula to extract the Buyer names

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Formula to give list sheet names
    By dluhut in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2019, 12:15 AM
  2. String combining column names. Extract values from these columns.
    By regresss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2015, 06:20 PM
  3. Replies: 7
    Last Post: 10-07-2015, 03:01 PM
  4. Extract column names by searching Row 1 header names?
    By Syfy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2015, 07:27 PM
  5. Replies: 2
    Last Post: 04-16-2014, 05:13 PM
  6. Buyer Vs Seller Matching Formula
    By carl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 03:10 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