+ 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
    Excel 2010
    Posts
    2,483

    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... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    32,019

    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



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    32,019

    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
    Excel 2010
    Posts
    2,483

    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... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    32,019

    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. [SOLVED] 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