| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate two dates from a text string into two separate cells
Hi again!
I have a "Start and End Date" named column with text like this: Sep 24/08-Sep 24/08 Apr 4/08- Apr 30/08 Feb 1/08-Feb 20/08 Dec 1/07- Dec 31/07 I would like create a column for the Start Date and another column beside it for the End Date. How can I achieve this? :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separate two dates from a text string into two separate cells
Data - Text to Columns
Delimited Find - "Tacrier" wrote: Hi again! I have a "Start and End Date" named column with text like this: Sep 24/08-Sep 24/08 Apr 4/08- Apr 30/08 Feb 1/08-Feb 20/08 Dec 1/07- Dec 31/07 I would like create a column for the Start Date and another column beside it for the End Date. How can I achieve this? :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separate two dates from a text string into two separate cells
Thank you again Sean Timmons, it worked!!
Before, I spent about three hours manually separating the dates and your formula worked in 5 seconds lol Awesome. :) "Sean Timmons" wrote: Data - Text to Columns Delimited Find - "Tacrier" wrote: Hi again! I have a "Start and End Date" named column with text like this: Sep 24/08-Sep 24/08 Apr 4/08- Apr 30/08 Feb 1/08-Feb 20/08 Dec 1/07- Dec 31/07 I would like create a column for the Start Date and another column beside it for the End Date. How can I achieve this? :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
separate two dates from a text string into two separate cells
Oops! :-)
"Tacrier" wrote: Thank you again Sean Timmons, it worked!! Before, I spent about three hours manually separating the dates and your formula worked in 5 seconds lol Awesome. :) "Sean Timmons" wrote: Data - Text to Columns Delimited Find - "Tacrier" wrote: Hi again! I have a "Start and End Date" named column with text like this: Sep 24/08-Sep 24/08 Apr 4/08- Apr 30/08 Feb 1/08-Feb 20/08 Dec 1/07- Dec 31/07 I would like create a column for the Start Date and another column beside it for the End Date. How can I achieve this? :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to split number and text string to separate cells? | Excel Discussion (Misc queries) | |||
| separate text string | Excel Worksheet Functions | |||
| Parsing a text string into separate cells | Excel Worksheet Functions | |||
| Separate a FirstLast text string into two columns | Excel Discussion (Misc queries) | |||
| Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
