I want to be able to paste a csv file into a single cell in an excel spreadsheet and by applying a formula, selected cells will be auto populated with data from the csv file. The formula needs to take into account that fields in the csv file could be empty or could have 1+ chars.
The reason I want to do this is that in the future when I run data extracts, I can check the contents of the csv file by pasting it into a spreadsheet I have set up with all the database tables and column names in it.
I hope this makes sense. Your help will be much appreciated.
Bookmarks