Search end/beginning of cell
in [General]
|
Prev: '07 Large Operation Error (Delete / Insert Rows and/or Columns
Next: Splitting multiple cell contents from 1st column into 4 columns
From: msnyc07 on 28 Apr 2010 17:31 I know I can do this with functions but is there anyway to do search/replace indicating this? In word I just do ^pWord or Word^p but not sure how/if I can do this in Excel
From: Dave Peterson on 28 Apr 2010 20:04 For searching, you can look at the whole cell (match entire cell contents) And look for something like: MSNY* This will find the cells that start with MSNY *MSNY will find the cells that end with MSNY The replace is gonna be a problem for you (I bet). What do you want to start with and what do you want to end with? (save your work before you start. I'm guessing that it won't do what you want.) msnyc07 wrote: > > I know I can do this with functions but is there anyway to do search/replace > indicating this? In word I just do > > ^pWord > > or > > Word^p > > but not sure how/if I can do this in Excel -- Dave Peterson
From: Dave Peterson on 28 Apr 2010 20:05
Ps. If you don't see that Option (for matching the cell's contents), click the Options button. msnyc07 wrote: > > I know I can do this with functions but is there anyway to do search/replace > indicating this? In word I just do > > ^pWord > > or > > Word^p > > but not sure how/if I can do this in Excel -- Dave Peterson |