Find and Replace Cell Value

**SaadKiji** · 03-05-2016, 03:37 AM

Hi everyone,

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

Regards,
Saad

**udprocks** · 03-05-2016, 03:39 AM

definatly you can do. with a formula..for better understanding your query could you please upload a sample file, with expected result.

**SaadKiji** · 03-05-2016, 03:47 AM

Hi Udprocks,

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

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

Capture.PNG

Thanks

**udprocks** · 03-05-2016, 03:52 AM

Then try

If the data in column D

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

**SaadKiji** · 03-05-2016, 03:58 AM

It works, thank you

**udprocks** · 03-05-2016, 03:59 AM

Originally Posted by SaadKiji

It works, thank you

Glad it helps you, if your query solved please make your post title as solved.

**Pepe Le Mokko** · 03-05-2016, 04:26 AM

Alternatively withouit formulas

Ctrl+H

Find what OPERATOR
Replace with DRIVER

Click " Replace All" - Done

Re: Find and Replace Cell Value