| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing special characters in Excel 2007
I need to Replace all occurrences of '***' (three asterisks) in an Excel
column with '0' (one zero) or '000' (three zeros). The Find function finds all non-zero three digit values (which are numbers). Is there a way to find matches for three asterisks? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing special characters in Excel 2007
use ~ before your asterisks in the find box. thsi will find actual instances
of * "Jeff" wrote: I need to Replace all occurrences of '***' (three asterisks) in an Excel column with '0' (one zero) or '000' (three zeros). The Find function finds all non-zero three digit values (which are numbers). Is there a way to find matches for three asterisks? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing special characters in Excel 2007
Thank you Sean. That worked. Best, Jeff
"Sean Timmons" wrote: use ~ before your asterisks in the find box. thsi will find actual instances of * "Jeff" wrote: I need to Replace all occurrences of '***' (three asterisks) in an Excel column with '0' (one zero) or '000' (three zeros). The Find function finds all non-zero three digit values (which are numbers). Is there a way to find matches for three asterisks? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing special characters in Excel 2007
Thank you for the feedback!
"Jeff" wrote: Thank you Sean. That worked. Best, Jeff "Sean Timmons" wrote: use ~ before your asterisks in the find box. thsi will find actual instances of * "Jeff" wrote: I need to Replace all occurrences of '***' (three asterisks) in an Excel column with '0' (one zero) or '000' (three zeros). The Find function finds all non-zero three digit values (which are numbers). Is there a way to find matches for three asterisks? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Special characters in Excel | Excel Discussion (Misc queries) | |||
| Replacing wild card characters in EXCEL | Excel Discussion (Misc queries) | |||
| How do I search and replace special characters in Excel e.g. „¢ | Excel Discussion (Misc queries) | |||
| Excel 'Special' Characters in Expressions | Excel Worksheet Functions | |||
| Putting special characters into Excel... | Excel Discussion (Misc queries) | |||
Linear Mode
