+ Reply to Thread
Results 1 to 4 of 4

Search and replace a text plus dates combine

  1. #1
    Registered User
    Join Date
    06-26-2020
    Location
    Romania
    MS-Off Ver
    2019
    Posts
    2

    Search and replace a text plus dates combine

    Hello,

    I try to make a formula when a text (a code) which exists on a row from a column if match with partial text from other column then in the new column to replace that text found with the value from another column on the same row with that code. So if text on A match partial from C then on D replace that "A text" with "B text" - attached file sample with sheet1.

    Also, I will like to get some days grouped - the days marked with a colour (continuos days) to have as a result a cell where those days to be saved as a period (from / till). Attached sample on sheet 2.

    Can you please help me with this?

    Many thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: Search and replace a text plus dates combine

    On the Name and Codes sheet, If I understand correctly then I believe the following will do what you want (paste into cell D2 and drag the fill handle down):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    As for the dates that you would like to group by fill and font color, I feel that if that can be done it will require VBA.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    06-26-2020
    Location
    Romania
    MS-Off Ver
    2019
    Posts
    2

    Re: Search and replace a text plus dates combine

    Thank you, it works!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: Search and replace a text plus dates combine

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Search and replace Text Replace Formula
    By Vonblack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2019, 11:30 AM
  2. [SOLVED] How to replace specific text search for any date search
    By katiedee1625 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2018, 11:22 AM
  3. [SOLVED] Search through columns and find specific text and replace that text with header column
    By adamzee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 11:59 PM
  4. [SOLVED] VBA to Search a Text String, Find a Value listed in another column and replace the text
    By Jschrod303 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2012, 08:56 PM
  5. [SOLVED] search for text, then search for previous text, replace 1st text including number from 2nd
    By kldailey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2012, 05:23 PM
  6. How to combine vlookup and search text within cell
    By garriebartolome in forum Excel General
    Replies: 3
    Last Post: 04-14-2011, 09:43 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