Results 1 to 3 of 3

How do I compare just the first 10 characters in two sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    How do I compare just the first 10 characters in two sheets

    Match first 10 characters of one sheet with another sheet

    I have two sheets with company names.
    The company names in each file have been entered over the past year by numerous staff employees.
    Sometimes, the names entered are not consistent.
    For example, sheet2 has "Citigroup Inc" in one file and then sheet1 might type "Citigroup Co" in the other file.
    As well as sheet1 has "American International Group Inc" but sheet2 typed by "American International Company"

    Therefore, they are not a one to one match.

    I only need the first 10 characters of the words in sheet1 to match the first 10 characters of the words in column B.

    I want in sheet3 to only match the first 10 or so characters between each file. How do I do this? (Id, COmpany)

    I want in Sheet 4 to not matching/unmatched items. Is this possible?

    Please hep. Any help will be appreciate.
    Last edited by raw_geek; 01-10-2014 at 01:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare characters of two cells and return the result
    By shahid6634 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2012, 08:43 AM
  2. Compare characters in two columns
    By enhydra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2011, 11:22 AM
  3. Replies: 1
    Last Post: 10-19-2011, 07:48 AM
  4. Compare first 4 characters question
    By goodiein2808 in forum Excel General
    Replies: 6
    Last Post: 09-07-2011, 12:07 AM
  5. Replies: 4
    Last Post: 02-04-2007, 11:08 AM

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