+ Reply to Thread
Results 1 to 6 of 6

Comparing text string

  1. #1
    Registered User
    Join Date
    09-22-2018
    Location
    Stockholm
    MS-Off Ver
    2016
    Posts
    5

    Cool Comparing text string

    Hi all smart people out there! I'm so happy for you helping me before and wonder if you can crack this problem (attached).

    I´m looking for a formula that can compare two text-strings that can come in different formats.

    Thanks!

    Martin
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Comparing text string

    Is the mis-spelling of Saltstreet in A23 intentional?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    09-22-2018
    Location
    Stockholm
    MS-Off Ver
    2016
    Posts
    5

    Re: Comparing text string

    No, sorry - well spotted. I will attach a corrected example
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Comparing text string

    other than the misspelling of "Saltstreet" in A23 (as pointed out by Glenn), you could use this formula:

    Please Login or Register  to view this content.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Comparing text string

    Yep. That's pretty much what I would have gone for given the answer to my Q.

  6. #6
    Registered User
    Join Date
    09-22-2018
    Location
    Stockholm
    MS-Off Ver
    2016
    Posts
    5

    Re: Comparing text string

    Many thanks!

+ 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. Comparing text between string arrays and values in column
    By mustafasb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2017, 02:53 AM
  2. Replies: 2
    Last Post: 05-27-2016, 12:30 AM
  3. [SOLVED] Find partial text string within another text string return original text into cell.
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-17-2013, 02:58 PM
  4. Finding a date in a text string and comparing it to a date range
    By ABARAN1000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2012, 02:55 PM
  5. Searching & comparing text string in 2 columns
    By Murph in forum Excel General
    Replies: 10
    Last Post: 04-08-2011, 11:02 AM
  6. Comparing a string to a text file
    By Yerushalmi in forum Excel General
    Replies: 10
    Last Post: 12-06-2010, 04:42 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