Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperate date from text
Hello!
I really appreciate any help on this. I am sent files weekly that contain a column with the a date and text and I need to seperate them into two columns. Examples of values in the columns a 05/04/2008 day 05/05/2008 night 05/07/2008 day 05/08/2008 day etc. The text values are always only day or night but the dates are constantly changing. I already have a macro that will put day or night in a column next to it based on the cell value but the original column remains the same. Any suggestions on how to write a macro to do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperate date from text
Have you tried
Datatext to columnsfixed width (if all dates are the same length) -- Don Guillett Microsoft MVP Excel SalesAid Software "dnr" wrote in message ... Hello! I really appreciate any help on this. I am sent files weekly that contain a column with the a date and text and I need to seperate them into two columns. Examples of values in the columns a 05/04/2008 day 05/05/2008 night 05/07/2008 day 05/08/2008 day etc. The text values are always only day or night but the dates are constantly changing. I already have a macro that will put day or night in a column next to it based on the cell value but the original column remains the same. Any suggestions on how to write a macro to do this? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperate date from text
If you want to do it in code you could use language like this:
Sub testit() ActiveCell = CDate(Left(ActiveCell, 10)) End Sub "dnr" wrote: Hello! I really appreciate any help on this. I am sent files weekly that contain a column with the a date and text and I need to seperate them into two columns. Examples of values in the columns a 05/04/2008 day 05/05/2008 night 05/07/2008 day 05/08/2008 day etc. The text values are always only day or night but the dates are constantly changing. I already have a macro that will put day or night in a column next to it based on the cell value but the original column remains the same. Any suggestions on how to write a macro to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seperate date and time | Excel Worksheet Functions | |||
How do i convert a date into 3 seperate columns? | Excel Discussion (Misc queries) | |||
Seperate Date and Time | Excel Discussion (Misc queries) | |||
imported doc from pdf file, want to seperate text & date in cells | Excel Discussion (Misc queries) | |||
creating a date column from seperate data | Excel Worksheet Functions |