The text file import routines and functions presented in the previous post have been modified with the following additions:
Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space)
The SplitText function can also be used as a UDF, to split lines of text previously imported. In this case the most efficent way is to enter the UDF as an array function, operating on the complete range of text. In this way the UDF is only called once, returning a 2D array, and the whole operation is much quicker.