Find and Replace

  • Thread starter Thread starter alish
  • Start date Start date
A

alish

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.
 
Hi,

Select all the cells that you want to change from N to 0 and press Ctrl+H
enter N in the Find what box and 0 in the Replace with box and click Replace
All.
 
Shane, THanks for the reply, but that function will replace ALL "N" cells to
0. What I want is to replace only the given number, like if i select the
entire row and only replace 2 Ns out of 10. Each employee has 255 records in
one row, that means 255 days. And several of them are lebeled as "N"s. Mostly
15 to 20. There are two date-formatted columns. So i want to show the number
of "N"s based on the Start and End date columns. For example, for an emploee
the SrartDate of Non-Paid days ("N" cells) is 9/1/08 and EndDate is 9/15/08.
Supposedly I have to have 15 Ns. But the actual numbers of Ns start on
8/29/08. I want to replace the Ns with 0 on the cells from 8/29/08 through
8/31/08. in other words, i will be doing corrections. Thanks again.
 
Shane, THanks for the reply, but that function will replace ALL "N" cellsto
0. What I want is to replace only the given number, like if i select the
entire row and only replace 2 Ns out of 10. Each employee has 255 recordsin
one row, that means 255 days. And several of them are lebeled as "N"s. Mostly
15 to 20. There are two date-formatted columns. So i want to show the number
of "N"s based on the Start and End date columns. For example, for an emploee
the SrartDate of Non-Paid days ("N" cells) is 9/1/08 and EndDate is 9/15/08.
Supposedly I have to have 15 Ns.  But the actual numbers of Ns start on
8/29/08. I want to replace the Ns with 0 on the cells from 8/29/08 through
8/31/08. in other words, i will be doing corrections. Thanks again.

Hi Alish,

Might just be your wording but is there any chance you could supply
some data?
If you don't want to post it here you can mail it to me off list :)

Chris
 
Chris,

Yes, I am willing to send it to you off-list. Please give me your email
address. Thanks.
 
Back
Top