I am wanting to clean up data from a excel sheet and copy only needed data to a new sheet in the same workbook. The problem is all the data is stored in column A and is listed in the following format.

Name: LDAP Search
Source: MSAccess
Description: LDAP Search time 6.7 sec
Time: 4/8/2007

The above data is all stored in column A and need to be copied onto a new sheet in seperate colums for each item as listed below.

Column A Column B Column C Column D
Name Source Description Time
LDAP Search MSAccess LDAP Search time 4/8/2007


Is this something can be done or do i need to do this all manually?

Thanks for any suggestions.