+ Reply to Thread
Results 1 to 4 of 4

Substitute word by list

Hybrid View

  1. 02-04-2019, 11:51 AM #1
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Substitute word by list

    Please try

    T9 Key-in search

    R9
    =TEXT(D9,"hh:mm-")&SUBSTITUTE(SUBSTITUTE(C9,IFERROR(LOOKUP(1,-SEARCH($T$9:$T$17,C9),$T$9:$T$17),""),""),",","")
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  2. 02-05-2019, 02:50 AM #2
    vasc
    vasc is offline
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: Substitute word by list

    thank`s Bo_Ry workkkk....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA script to substitute text from an excel sheet into various word docs by filepath
    By tomca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2021, 05:57 PM
  2. Substitute using a named list
    By Hnorgaar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-03-2018, 03:13 AM
  3. [SOLVED] Is there another way to write INDEX(INDIRECT(SUBSTITUTE()),MATCH(OFFSET(SUBSTITUTE()))?
    By keby1nko in forum Excel General
    Replies: 4
    Last Post: 10-28-2014, 11:04 PM
  4. [SOLVED] Need a formula to find and substitute a word in a text if a condition is met...
    By danielneedssomehelp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-18-2014, 01:34 PM
  5. [SOLVED] How can I replace a word from a sentence in a cell & substitute word from another cell
    By rionoah in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2012, 08:44 AM
  6. SUBSTITUTE word in multiple cells
    By WEEZY760 in forum Excel General
    Replies: 5
    Last Post: 03-22-2012, 03:02 PM
  7. How to Substitute a Singular/Plural word to nothing in an Alphanumeric Text..?
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-01-2010, 06:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1