Messy Big Data to Structure Data

Hi,

I am working in finance department. Apparently, my boss was instructed me to perform big historical data from year 2011 until Jun 2014.
The historical data was extracted from General Ledger, Accounts Payable and Procurement in text document format with total of row and column are more than 145,000
and 15 respectively. I have noticed that some of these data are mixture of description,documents reference number, date of purchase,etc and the structure of data is not consistency. And also, some of data may used short form and needed to match with other reports.

For Example: Column A may consist of text, reference number and date ; text and date only; text and reference number and batch reference number with date only.

I have tried to used text functions , LEFT(), RIGHT(), LEN() and MID() but the formula only can applied to some cell only and cannot work out how to apply any formula to solve this issue. And also, I do not have any knowledge to use VBA.

Attached is the sample and also indicate the end result in Column B to F.

Is there any possible formula can be generated without using VBA.... Thank in advance.

KenjiChan

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)