There is a split function for Delimited data. It returns an array of the
individual fields in the record.

"jtrevill" wrote:


So - anyone know of a way to use Text To Columns, but by using VB
instead?

Thanks!


--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=314637