Many thanks Ross for your explanation. The Replace method works. But
could you also give *an illustration * of how the Split Fumction could
be used. The Help file is very reticent on this.


David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=480974