| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Part of a cell value
Using Data Text to columns will work if the data is still in text format.
However, if Excel converted the date and time stamps to dateserial values (numbers), then you may have to insert a new column to the right of the Date/Time, and use a formula: B1: =Int(A1) Copy and PasteSpecial the values back into the column, then delete the original column of Date/Time. -- Regards, Bill Renaud |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting part of X-axis range | Charts and Charting in Excel | |||
| Globally deleting part of the information in a cell | Excel Worksheet Functions | |||
| Deleting part of the infomation in a cell | Excel Discussion (Misc queries) | |||
| Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
| Deleting part of a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
