+ Reply to Thread
Results 1 to 2 of 2

Replace all text in column but set values (phrases)

  1. #1
    Registered User
    Join Date
    01-03-2021
    Location
    Indiana
    MS-Off Ver
    365
    Posts
    31

    Replace all text in column but set values (phrases)

    Hi, I have a column (6000+rows) full notes people have made. I need to remove all the text but the text "signed with a date" and "agreement with the date". Is it possible to do that?
    Thank you for your time
    Kim

  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
    44,053

    Re: Replace all text in column but set values (phrases)

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

    REMOVE any confidential information!!
    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

+ 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: 12-08-2021, 06:42 PM
  2. [SOLVED] VBA Macro to find text string in one column and replace specific text in another column if
    By bmahfood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2017, 11:15 AM
  3. Find Phrases and copy text in between
    By Cbaffoni87 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-07-2015, 03:45 PM
  4. Filter column by text, then export column to new workbook, replace searched text with new.
    By Headhunter234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2015, 07:48 AM
  5. Compare lists of phrases in two workbooks and import only missing phrases
    By Fireblejd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2011, 06:59 AM
  6. [SOLVED] Use of Text Phrases in Excel Functions
    By Girija in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2006, 02:35 AM
  7. How to Replace Numbers with Phrases
    By Jerry Arnone, PMP in forum Excel General
    Replies: 0
    Last Post: 06-29-2005, 08:05 AM

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