Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and replace for date format
I need to reformat dates within two columns. Currently, I have dates
formatted like this: 1/22-1/28 (a starting and ending date) I've broken this date out into two columns (start_date) and (end_date) Now, I need to do a find and replace to elminate the suffix of the date format for the start_date column and then elimate the prefix of the date format for the end_date column So, that I'll have for the start_date column: 1/22 and for the end_date column: 1/28 how can I do a find and replace to accomplish this? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find & Replace text format | Excel Discussion (Misc queries) | |||
find replace format | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |