| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel wildcard ? for replacing strings in dropdown function
When I use the find/replace the "?" replaces characters in a string. Example:
Cells: abcd, abdf, abxs, abrd..... Find: ab?? Replace with :bc?? This results with all cells: bc?? How can I use the wildcard so that the results of the replace a bccd, bcdf, bcxs, bcrd... without having Excel replace the last part of the string with ??. I can't find a help screen that describes this option ? in repplacing. This work fine in WORD. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel wildcard ? for replacing strings in dropdown function
Select your range
Find: ab Replace with: bc Replace All "Excel Wildcard ? Replace" wrote: When I use the find/replace the "?" replaces characters in a string. Example: Cells: abcd, abdf, abxs, abrd..... Find: ab?? Replace with :bc?? This results with all cells: bc?? How can I use the wildcard so that the results of the replace a bccd, bcdf, bcxs, bcrd... without having Excel replace the last part of the string with ??. I can't find a help screen that describes this option ? in repplacing. This work fine in WORD. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
| Need Excel Function to FIND Text - Help! | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Linear Mode
