Closed Thread
Results 1 to 2 of 2

How to derive same word when few characters in 2 words are different.

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    How to derive same word when few characters in 2 words are different.

    Dear Friends.

    This is in continuation of my previous post. I apologise for my previous post's title.

    PFA

    Is there any way where we can derive output mentioned in W5, W6.

    Formula in cells W2:W4 is give by the forum. But it fails in W5, W6.

    I need to reconcile huge database and manually doing the task is very time consuming and there are chances of making errors also.

    Please assist.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,209

    Re: How to derive same word when few characters in 2 words are different.

    Duplicate threads are not allowed.

    Go back to the original thread and change the title as requested - there are instructions about how to do so there.

    This thread is closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

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

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