Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace multiple entries in excel state=st west=w east=e continue
How can I replace more then one word at a time using the replace function on
excell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace multiple entries in excel state=st west=w east=e conti
Please HELP
"Bob" wrote: I think there has to be a way that I can set-up a group of word that everytime they get copy to a sheet become there abbreviations. "Bob" wrote: I can replace state with st. or west with w. The problem is I have to do each word seperate. Is there a I can replace everytime I paste west,east,south,north,and more with one function. "Teethless mama" wrote: Highlight your data range Go to Edit Replace Find What: Example 1 Replace With: Example 2 Replace All All the Example 1 will replace with Example 2 "Bob" wrote: How can I replace more then one word at a time using the replace function on excell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to you open multiple versions of Excel | Excel Discussion (Misc queries) | |||
How can I replace multiple data in excel ? | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
opening multiple instances of excel | Excel Discussion (Misc queries) |