+ Reply to Thread
Results 1 to 7 of 7

Find and Replace Cell Value

  1. #1
    Registered User
    Join Date
    02-16-2016
    Location
    Qatar
    MS-Off Ver
    Office 365
    Posts
    12

    Post Find and Replace Cell Value

    Hi everyone,

    Is there a formula to find a value and replace it rather than Find Tool in Excel.

    Regards,
    Saad

  2. #2
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    349

    Re: Find and Replace Cell Value

    definatly you can do. with a formula..for better understanding your query could you please upload a sample file, with expected result.
    If answer helped you say Thanks by Add Reputation

  3. #3
    Registered User
    Join Date
    02-16-2016
    Location
    Qatar
    MS-Off Ver
    Office 365
    Posts
    12

    Re: Find and Replace Cell Value

    Hi Udprocks,

    Please find attached image, I couldn't upload a file?

    I need to replace "OPERATOR" with "DRIVER".

    Capture.PNG

    Thanks

  4. #4
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    349

    Re: Find and Replace Cell Value

    Then try

    If the data in column D

    =SUBSTITUTE(D1,"Operator","Driver")

  5. #5
    Registered User
    Join Date
    02-16-2016
    Location
    Qatar
    MS-Off Ver
    Office 365
    Posts
    12

    Re: Find and Replace Cell Value

    It works, thank you

  6. #6
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    349

    Re: Find and Replace Cell Value

    Quote Originally Posted by SaadKiji View Post
    It works, thank you
    Glad it helps you, if your query solved please make your post title as solved.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,895

    Re: Find and Replace Cell Value

    Alternatively withouit formulas

    Ctrl+H

    Find what OPERATOR
    Replace with DRIVER

    Click " Replace All" - Done

+ 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: 16
    Last Post: 12-02-2014, 03:38 PM
  2. How to find x in all ws _ replace x by value at cell B in same row then sum each row
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2014, 03:09 AM
  3. Find and replace but replace value of cell 3 columns along
    By batchjb69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 10:57 AM
  4. Find value from one cell and replace to another
    By akibahoward in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-29-2012, 02:54 PM
  5. Find & Replace Whole Cell
    By sethmote in forum Excel General
    Replies: 1
    Last Post: 01-22-2010, 11:58 AM
  6. Find/Replace with the value of a cell
    By c0ckR0ach in forum Excel General
    Replies: 2
    Last Post: 09-29-2009, 05:10 AM
  7. Find, Replace with and then replace adjacent cell
    By Craig2097 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2009, 12:42 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