Looking at your origingal question I was initailly unsure just how many items
you needed to get from your string. For 2 the Instr function is great. For
more I use the split function, but both work just fine...
--
HTH...

Jim Thomlinson


"Glen" wrote:

Thank you both. I was just using the InStr function while you two were
replying to see if it would work for me and it seems to do the job. I
am going to try the split just to see how it goes and keep it for
future reference. Thanks again to both of you.