Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I not show certain Letters in a range of cells in excel?
I'm creating a huge excel file to show all of our employee's vacation. Each
employee has their own worksheet and the last worksheet in the file is a complete calendar of everyone and when they are on vacation. This last worksheet is the only worksheet that gets sent out to all the employee's. Now my problem is that when the employee's are sick I put in an S. So now all the other employee's can see when that person was sick. I want to know if I can just in that last worksheet make any cells that have an S in them to be blank. Anyone know how to do this??? Any suggestions would be great. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I not show certain Letters in a range of cells in excel?
Make a copy of the worksheet.
Remove the "S" before sending it out. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Taryn McGregor" <Taryn wrote in message I'm creating a huge excel file to show all of our employee's vacation. Each employee has their own worksheet and the last worksheet in the file is a complete calendar of everyone and when they are on vacation. This last worksheet is the only worksheet that gets sent out to all the employee's. Now my problem is that when the employee's are sick I put in an S. So now all the other employee's can see when that person was sick. I want to know if I can just in that last worksheet make any cells that have an S in them to be blank. Anyone know how to do this??? Any suggestions would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate two currency cells to show a price range? | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
total a range of cells in Excel into a different worksheet | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |