+ Reply to Thread
Results 1 to 5 of 5

first 4 equal to next 4 letters

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,600

    first 4 equal to next 4 letters

    i have this on a1

    anearing
    neopagan
    ongaonga
    magainin

    want formula on b1 where results should be as follows

    N
    N
    Y
    N

  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,900

    Re: first 4 equal to next 4 letters

    Try, for T/F:

    =LEFT(A1,4)=RIGHT(A1,4)

    or (for Y/N)

    =IF(LEFT(A1,4)=RIGHT(A1,4),"Y","N")
    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
    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,900

    Re: first 4 equal to next 4 letters

    or... if the strings can be >8 characters...

    =IF(LEFT(A1,4)=MID(A1,5,4),"Y","N")

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,600

    Re: first 4 equal to next 4 letters

    Thank you Glenn , glad too got the reply too quick

  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,900

    Re: first 4 equal to next 4 letters

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ 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. Replies: 2
    Last Post: 02-12-2018, 01:50 PM
  2. Letters V or S equal to 0
    By graiggoriz in forum Excel General
    Replies: 2
    Last Post: 04-19-2017, 05:45 AM
  3. i need a formula for the sum of letters thart equal numbers
    By ERASHID in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2015, 05:45 AM
  4. [SOLVED] Summing letters that equal numbers
    By M. McGee in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2013, 03:12 PM
  5. Replies: 2
    Last Post: 09-28-2011, 12:07 PM
  6. Making letters equal number values for semester and exam grades
    By Pfisch87 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-10-2011, 07:44 PM
  7. I want a series of letters to equal a dollar amount?
    By awhitaker in forum Excel General
    Replies: 1
    Last Post: 05-17-2005, 09:06 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