Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Substring! HELP

  1. #1
    Join Date
    13th December 2016
    Location
    Argentina
    Posts
    8

    Substring! HELP

    Hi all, i need some help regarding SQL.

    i have a column in a table (let's say A.) which contains data like this:

    MATTHIEU FOURNIER
    Computacenter AG & Co oHG
    KPMG
    WA DET
    LENOVO
    WOOLWORTHS LIMITED
    LENOVO C/O DHL Supply Chain
    Deutsche Telekom / T-Systems


    what i need is to be able to identify names from those lines, for example Fournier only and look for that name in another table( B), if there is a match then select the match from the table B and fill another column from table A.

    it's something like the fuzzylookup from excel.

    problem: i do not know when the name is going to appear, i do not know the lenght nor the start. it could be in the middle, start or end.

    do you know if this is going to have any kind of solution? i've tried with the substring, however it's not solving my problem.

    thanks in advance!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th November 2006
    Posts
    1,584

    Re: Substring! HELP

    Hello,

    You can test following formula

    VB:
    =Match("*"&"Fournier"&"*",YourReferenceRange,0) 
    
    
    Hope this will help

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. How To Extract Certain substring within a cell of Strings
    By ohyaitsysh in forum Excel VBA / Macros
    Replies: 3
    Last Post: June 3rd, 2016, 07:16
  2. Count Cells with Substring
    By black31cat in forum Excel General
    Replies: 1
    Last Post: April 1st, 2014, 17:56
  3. Substring?
    By jaypatel in forum Excel and/or SQL Help
    Replies: 1
    Last Post: September 28th, 2006, 21:33
  4. Getting substring data from database
    By cclai in forum Excel and/or SQL Help
    Replies: 3
    Last Post: August 10th, 2006, 19:38
  5. Substring of Text
    By MOHLTC in forum Excel General
    Replies: 2
    Last Post: December 15th, 2005, 06:00

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
  •  
porno