| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep text matching a wildcard spec in replace/substitute
I want to replace a text string (in many formulas) that contains fixed
initial and terminal strings to be replaced and an intermediate string that needs to be left in place. For example I want to change: VLOOKUP(<inter-string, 1, FALSE) into MATCH(<inter-string, 0) How can I do this when the REPLACE command does not preserve the text matching the wildcard * character? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace/Substitute Formulas | Excel Worksheet Functions | |||
| How to substitute a comma with a newline char using Replace. | Excel Discussion (Misc queries) | |||
| Substitute/Replace | Charts and Charting in Excel | |||
| Replace or Substitute for COMBIN function | Excel Discussion (Misc queries) | |||
| Substitute ,replace and delete in a cell. | Excel Worksheet Functions | |||
Threaded Mode
