Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change one repeated word in the spreadsheet to another?
If I've used a word multiple times in a worksheet and want to change them all
to another word. ie: all words"exhibit" changed to "show". How can I do this? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change one repeated word in the spreadsheet to another?
Use Edit | Replace (or CTRL-H). Type exhibit in the Find What box, type
show in the Replace With box and click Replace All. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change one repeated word in the spreadsheet to another?
Sorry, I should have said highlight the block of cells first, then
CTRL-H. Pete |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change one repeated word in the spreadsheet to another?
Largo
CTRL + a(twice in Ver. 2003) to select all cells. EditReplace What: exhibit With: show In options check "match entire cell contents" or not depending upon if "exhibit" is in cells with other text or by itself. Replace all Gord Dibben Excel MVP On Thu, 15 Dec 2005 12:22:02 -0800, "Largo" wrote: If I've used a word multiple times in a worksheet and want to change them all to another word. ie: all words"exhibit" changed to "show". How can I do this? Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change one repeated word in the spreadsheet to another?
Ctrl+H
-- Regards, Dave "Largo" wrote: If I've used a word multiple times in a worksheet and want to change them all to another word. ie: all words"exhibit" changed to "show". How can I do this? Thank you |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change one repeated word in the spreadsheet to another?
Select the column('s) and go to EDIT - Find and Replace -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=493934 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change case on a spreadsheet from Caps to Sentence? | Excel Discussion (Misc queries) | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel | |||
Is it possible to link an Excel spreadsheet to a Word document an. | Excel Discussion (Misc queries) | |||
how do i import an excel spreadsheet to a word document | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |