| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace only "A*" by an other text
Hello,
I have a column which contains text like A, A*,AI,AT,D, etc. I would like to replace only the A* value by A-* using vba (because excel consider the A* as any text beginning by A). My formula below doesn't work. Any idea? Thanks! Cells.Replace What:="A*", Replacement:="A-*", LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| Vlookup, replace true text result with "X" | Excel Worksheet Functions | |||
| Macro to Replace/Delete Text Using "Watchword" List? | Excel Discussion (Misc queries) | |||
| Find and Replace causing a "Text" cell to become a custom date--wh | Excel Discussion (Misc queries) | |||
| Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
Threaded Mode
