Undelimiting a cell 1

[AlexIT]

I keyword searched and found a few good script examples to create a cell merging other cells and using a specified delimiter, but I have a single cell being generated by an outside system that I need to split into multiple cells by the delimiter...note this is not a file imported to excel, but an automatically generated excel file that I need to reference. Finally, the number of characters vary from cell to cell. Can I read each character into a string variable individually and stop when I notice the delimiter?

Thanks,
Alex

 

[Zathras]

Have you looked at "Text to Columns..." from the Data menu?

 

[AlexIT]

Thanks, I wonder why the annoying paper clip didn't suggest it?

Alex