Changing a date within a cell

D

david72

Hi

Could someone please help me.

I have the same data in approximately 50 sheets and was wondering i
there was any way I could change the date within the cell withou
typing the date in manually 50 times. For example.

I have separate cells that contain the below data:

CBA Sep 06
NAB Sep 06
WBC Sep 06

How do I change the above cells to reflect Oct 06?

Thanks
For your help
Davi
 
P

Pete_UK

This data must be text if it is in the same cell. Hence you can use
Find & Replace (CTRL-H) to look for "Sep" and replace it with "Oct"
(without the quotes). You can group the sheets together, highlight the
appropriate cells (assuming they are in similar locations on each
sheet) and do the operation on them all.

Hope this helps.

Pete
 
Top