Find & Replace: find part cell, replace whole cell

K

katy

I would like to be able to do a Find & Replace where I find any cell which
contains a certain text string within the cell contents, and replaces the
WHOLE CELL with another text string. Anyone know of a simple way to do this?

Specifically, I have a large number of cells with contents like
01/06/2008 - 30/06/2008
The first date is always the same but the second date can be any one of
hundreds of dates. I want to find all cells which start "01/06/2008" and
replace the whole cell with "2008-09". It seems that if I do a Find &
Replace (ctrl-H) without 'match entire cell contents' selected, then only the
first part of the cell is replaced and the second date remains (not what I
want), but to get a 'match entire cell contents' to work, I would have to do
a separate Find & Replace for every possible original value of the cell
(hundreds of possibilities).

I'm not great with VBA, but I tried recording a macro while I did the Find &
Replace, to see if I could then amend the code to make it work, but it didn't
look easy to do it this way so I think I need an entirely new bit of code!
Any ideas...?

Thanks
Katy
 
K

katy

D'oh - all I needed was a wildcard (*):
Find "01/06/2008*" and replace with "2008-09"
Apologies for wasting people's time! : )
 
R

radicaltp

beautiful . love u katy:)

katy said:
D'oh - all I needed was a wildcard (*):
Find "01/06/2008*" and replace with "2008-09"
Apologies for wasting people's time! : )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top