View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
msnyc07 msnyc07 is offline
external usenet poster
 
Posts: 93
Default 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'...