| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace using *
I am using Excel 2002. I have a column that contains text. Within this text
are multiple *. I would like to replace them with nothing using the find and replace option. The problem is when I put the * in the find filed Excel assumes it is a wild card and replaces the entire field with blank. How do I tell Excel the * is not a wild card but an actual character. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace using *
Use ~*
"Laura Beth" wrote: I am using Excel 2002. I have a column that contains text. Within this text are multiple *. I would like to replace them with nothing using the find and replace option. The problem is when I put the * in the find filed Excel assumes it is a wild card and replaces the entire field with blank. How do I tell Excel the * is not a wild card but an actual character. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace using *
Thanks for the tip, Mr. Carey.
-- Sincerely, Michael Colvin "Duke Carey" wrote: Use ~* "Laura Beth" wrote: I am using Excel 2002. I have a column that contains text. Within this text are multiple *. I would like to replace them with nothing using the find and replace option. The problem is when I put the * in the find filed Excel assumes it is a wild card and replaces the entire field with blank. How do I tell Excel the * is not a wild card but an actual character. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace numbers in a value NOT a formula? | Excel Discussion (Misc queries) | |||
| Search and replace | Excel Worksheet Functions | |||
| replace absolute references | Excel Worksheet Functions | |||
| REPLACE outside of highlighted column | Excel Worksheet Functions | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Linear Mode
