+ Reply to Thread
Results 1 to 19 of 19

Add a string between beginning and and of a chain per corresponding code

Hybrid View

  1. #1
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,434

    Re: Add a string between beginning and and of a chain per corresponding code

    Put this formula in D1:

    =A1

    and this one in D2:

    =IF(OR(ISNUMBER(SEARCH("beginning",A2)),ISNUMBER(SEARCH("end",A2))),A2,IF(COUNTIF(A$1:A1,"*beginning")=COUNTIF(A$1:A1,"*end"),A2,A2&" between"))

    Copy the formula from D2 down as far as you need to.

    Hope this helps.

    Pete

  2. #2
    Registered User
    Join Date
    02-09-2017
    Location
    Atlanta, GA
    MS-Off Ver
    2010
    Posts
    11

    Re: Add a string between beginning and and of a chain per corresponding code

    Thank you AlphaFrog!!!
    Can I just put E1 (and E where column A is in code) if I want this to work for column E?

+ 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: 1
    Last Post: 04-12-2014, 04:03 PM
  2. Need Help generating a and copying a chain of code.
    By borderpc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2013, 01:36 PM
  3. Move Text From End Of String To Beginning
    By Tellm in forum Excel General
    Replies: 4
    Last Post: 06-28-2013, 06:09 AM
  4. Replies: 5
    Last Post: 09-08-2010, 03:45 PM
  5. Replies: 3
    Last Post: 09-08-2010, 09:49 AM
  6. Add a string at the beginning and end
    By patyandra in forum Excel General
    Replies: 2
    Last Post: 12-05-2009, 07:05 PM
  7. [SOLVED] Is there away to add a zero to the beginning of number string?
    By Anthony in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2006, 06:55 PM

Tags for this Thread

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