I have about 15 workbooks that I aggregate data from. So "sheet 1" would be linked to these documents. as they are updated the file will automatically update. Meaning text-to-columns is useless. I would have to do text to columns over again. Also the naming conventions can have up to 12 periods (.), but I only want the first few. That is why I named this thread delimiting with a formula.

Thanks

---------- Post added at 02:21 PM ---------- Previous post was at 02:20 PM ----------

If you look I have done it with the first 2, but after that I have a weird issue... Anyone know what I've done wrong and how I can continue a few other columns?