| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing Part of a Cell's Content
Is there a way to change part of a cell's content? I have the following data -
7/7/2008 1:25:00 PM 7/7/2008 1:18:00 PM 7/7/2008 6:19:00 PM 7/7/2008 12:34:00 AM I want to change 7/7/2008 to Jul-07 but still keep the time the way it is. I can change the way the data is viewed (using Format, Cell, Number) but it doesn't change the actual data in the cell. If I do a Replace command it replaces all the data and I lose the time information. I need to change the date data because if not I cannot get a COUNT IF function to work on it. Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to refer to a cell's address, not it's content... | Excel Discussion (Misc queries) | |||
| Printing cell's content larger than cell width | New Users to Excel | |||
| Replacing Table_array to a cell content | Excel Worksheet Functions | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
| How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
