Hello Again, hopefully this will be the last time I annoy anyone for a Solution.
The provided Data (attached) is where I am try to extract the Date and such is Driving me to the Wall.
Each Description is different and that's why formula or VBA has been working on some rows and not others.
Some Strings have full dates in them, others have just month and year and the rest have none or even week numbers.
Dates and Excel don't get along well it seems![]()
Thank you for the attempt to resolve this matter.
Cheers
OP
Bookmarks