Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |