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.
Bookmarks