0
The replace command in Excel is the same as the replace command in other programs such as Word. If you want to change one word throughout the worksheet (or workbook, there is an option for that) you can use the replace command rather than changing each instance manually. You define the word (or phrase, number, character, whatever) that you want to remove and define what you want to replace it with.
For example if you had used the name Jane 47 times in the spreadsheet and needed to change it to James, you could use find and replace to do all at once.
If you copied the same typo throughout a spreadsheet you could use the command to fix all instances at once.
Be careful though, Excel can't tell the difference between a word and the same word as part of a larger word. For example if you wanted to replace the word "me" with the word "you" and used this command it would change words like "same" and "mean" to "sayou" and "youan"!
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
In Excel what is the list of commands associated in the select command?
A submenu command
What command will lock rows and columns in position on the screen in Excel?
Freeze command
How do you use the replace command?
'replace' is not a standard Unix command. There is a replace command in mySql, but I don't know if this is the one you are referring to.
Which command cannot be reversed with Excel's Undo feature?
The Save command cannot be undone.
How do you repeat a same command in Microsoft Excel?
Pressing the F4 key will repeat the last command.
How do you replace all text all at once in Microsoft Excel?
The Find and Replace option can be used to replace text in Excel. A particular piece of text can be replaced throughout the document using Replace All. Use Ctrl - H to activate the Replace option in Excel.
Which Excel 2010 ribbon command located on the Formulas tab has a larger F next to the little x?
Insert Function is the Excel ribbon command on the Formulas tab that is marked "Fx"
What is the Excel command that enables you to specify rows and columns?
Print Titles is the command that enables you to specify rows and columns.
What does the width adjustment command do in excel?
The column width command adjusts the width of a column or selected range of columns.
What is an excel command?
Excel is a Microsoft product. It has many commands, such as "Save the File", import, export, copy are all commands.
What is the command used to remove cells and data from the worksheet in excel?
Delete
How do you replace 2011 with 2012 in multiple columns in excel?
Use Find and Replace.
