Find and Replace
 

Hi All, Happy New Year to everyone!!! Hey, I have a question: i have a
spreadsheet in which several cells in one row have the sameinformation, let's
say letter "N", as non-paid. the columnsare dates. And also i have columns
with "StartDate" and "EndDate". like for example, an employee has "N"
(non-paid) days from 9/1/08 through 9/15/08, but after the research the first
2 days are paid. so i need to change the first "N" days to "0". How do i make
excel to do that operation for me? Thanks in advance.

Find and Replace
 

You have followup questions at your other thread.

alish wrote:

Hi All, Happy New Year to everyone!!! Hey, I have a question: i have a
spreadsheet in which several cells in one row have the sameinformation, let's
say letter "N", as non-paid. the columnsare dates. And also i have columns
with "StartDate" and "EndDate". like for example, an employee has "N"
(non-paid) days from 9/1/08 through 9/15/08, but after the research the first
2 days are paid. so i need to change the first "N" days to "0". How do i make
excel to do that operation for me? Thanks in advance.

--

Dave Peterson