try <data<text 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