+ 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).

    Im 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... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,926

    Re: Comparing text string

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



  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
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    861

    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... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,926

    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