Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Way do do search/replace on beginning/end of cell w/o functions?
Hi, I've been writing various functions to search/replace beginning/ends of
cells, however wondering if there is a way to do the simpler ones with just Search/Replace function. In word I'd just do ^pString orString^p but not sure if there is a symbol I can use to mean beginning/end of cell. For instance I want to replace all Cells with Board Certified but not where * Board Certified I can of course write a function but the sheet is unwieldy as it is and it is a simple 'request'... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
End/Beginning of Cell Search/Replace? | Excel Worksheet Functions | |||
Search and Replace Entire Cell Content | Excel Discussion (Misc queries) | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
cell format changing when when using search and replace. | Excel Discussion (Misc queries) | |||
cell format changing when when using search and replace. | Excel Discussion (Misc queries) |