Results 1 to 8 of 8

Formula to find a match with different string lengths

Threaded View

  1. 08-06-2013, 04:21 PM #1
    mcranda
    mcranda is offline
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Formula to find a match with different string lengths

    I have Two columns of data where I am trying to make sure the numbers in both columns match.

    For example, line 2

    SearchTerm Customer material
    0034 05 10 0034 05 10 MFG OBSOLETE

    I just want to make sure that 0034 05 10 match in each column. The string length is not consistent.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM
  2. Trim/parse from right within cell - string lengths different
    By oprpjm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2013, 03:55 PM
  3. [SOLVED] Find Exact Match Text String Using Formula
    By sweetrevelation in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2012, 10:53 AM
  4. Can I extract numbers from a text string (of varying lengths) and use them?
    By kategg in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 11:36 AM
  5. CONCATENATE Spacing Issue Due to String Lengths
    By ffmariners in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2008, 02:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1