Replacing a value in MS Excel

Asked By ricarey 0 points N/A Posted on - 04/04/2012

Hi.

I am currently working on some list using MS Excel 2007.

I would like to ask someone about this particular thing so that I could make my work much more easier.

I am going to do some edit by replacing all the same value into another.

Is there a way I could replace them all at the same time to lessen the hassle?

• Status: Open
• Question Views: 961
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sophia Taj

Go To Solution

Best Answer

Best Answer

Answered By Sophia Taj 0 points N/A #100674

Replacing a value in MS Excel

 Hi Ricarey,

To replace any value in M S Excel 2007 follow below steps:

(1) Go to File menu -> and select  Find & Replace tab as indicated in below figure.

(2)After selecting Find & Replace tab -> select Replace , it will open up one dialog box as indicated in below image

In this dialog box you can replace whatever value you want to replace.

Thanks,

Sophia Taj.

About Sophia Taj

Questions
1

Answers
13

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 04/04/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #100675

Replacing a value in MS Excel

If you want an easier way, I think I have a few tricks to get you going. Follow these steps:

1. Press CTRL+F.

2. Click on the “Replace” Tab. Look for the “Find what:” text box and key-in the word that you want to replace.

3. Then look for “Replace with:” text box and key-in the text you want to replace the words in the latter.

4. After that click “Replace All” to replace the word similar to the one you want to replace or “Replace” to replace it one by one.

And you’re done. Hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/08/2012
• Question Category: MS Excel