|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 30th, 2005, 04:53 PM
|
|||
|
|||
how do i seperate data from one column into two seperate ones in .
how would i seperate the data below (which is currently in one column) into
two seperate columns based on date/time? 2/16/2005 1:09:09 PM 
|
|
#2
March 30th, 2005, 04:57 PM
|
|||
|
|||
|
try datatext to columns using space as your delimitor
"Nikki" wrote: how would i seperate the data below (which is currently in one column) into two seperate columns based on date/time? 2/16/2005 1:09:09 PM
|
|
#3
March 30th, 2005, 08:31 PM
|
|||
|
|||
|
copy the text and then select paste special and select space delineated.
"bj" wrote: try datatext to columns using space as your delimitor "Nikki" wrote: how would i seperate the data below (which is currently in one column) into two seperate columns based on date/time? 2/16/2005 1:09:09 PM
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
| need funct to match data in 3 seperate spreadsheets column 1 to v. | lucky | General Discussion | 2 | February 8th, 2005 07:33 PM |
| multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |
| SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
| Retaining Data Point Colors while Deleting a previously plotted Column? | Ken Black | Charts and Charting | 4 | October 17th, 2003 03:54 PM |
Linear Mode
