See attachment.
When I copied my travel expenses into an Excel spreadsheet, all of the data/text was combined into column A. Is there a way or formula that can separate the traveler names, traveling date and $ amount into separate columns?
Example.
02/06/07 AP 018 18810 034551 0600 Domestic Travel Smith 02/02 992.30
Objective:
Column A Column B Column C
Traveler Travel Date Amount
Smith 02/02 992.30
TIA
Excel Newby
Bookmarks