+ Reply to Thread
Results 1 to 2 of 2

How to detect a string that has repeated words?

  1. #1
    Registered User
    Join Date
    05-18-2020
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    27

    How to detect a string that has repeated words?

    Hi,
    I have a list of title; however, some of them are repeated in a same cell
    for example:
    "Behind Blue Eyes"
    "Better Man Better Man"
    "You Know My Name You Know My Name"
    "Word Up"

    I want to detect the strings like "Better Man Better Man" and "You Know My Name You Know My Name"
    Thank you!
    (English is not my native language so i'm sorry if my writing is too hard to understand)
    Last edited by TiberSeptim; 05-19-2020 at 10:06 PM.

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,475

    Re: How to detect a string that has repeated words?

    Assuming the text in your cells are not surrounded by quote marks...

    =IF(LEFT(A2,LEN(A2)/2)=TRIM(RIGHT(A2,LEN(A2)/2)),"Double","")
    Last edited by Rick Rothstein; 05-19-2020 at 09:38 PM.

+ 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. [SOLVED] Repeated words: remove duplicates, display word along with the number of times repeated
    By number9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-24-2019, 03:32 PM
  2. [SOLVED] detect recurring subsets of * doubles, threes, quadruples of numbers repeated in lottery
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-30-2019, 03:03 AM
  3. Replies: 1
    Last Post: 07-06-2019, 08:54 AM
  4. Replies: 1
    Last Post: 05-18-2018, 06:38 AM
  5. Replies: 1
    Last Post: 07-02-2014, 12:02 PM
  6. Macro to detect key words
    By dnaauto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2013, 03:00 PM
  7. Extract repeated words from Text string
    By Calman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2007, 10:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1