Don't quite get what you're after.

Where are the dates entered?

Where is PI- entered?

Maybe just editreplace

what: PI-

with: PI-Turbo

replace all.

Post a sample of a half dozen rows of your data layout.


Gord Dibben MS Excel MVP

On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote:

Hello,

I am doing a little assignment for school.

I have a product name P1- and I have sold it during 2 years: 2005 and 2006.
All of those sales with different months and days.
The name needs to be change- it is renamed P1-Turbo in 2006

How can I do that? Can I use an IF function? If so, how can I input the date
if the data contains different days and months???


Thanks