Thanks!
It seems to work well! I have not tested it to much yet.

Thank you for all of your help!
Bruce

"Ron Rosenfeld" wrote in message
...
On Tue, 29 May 2007 16:26:31 -0400, Ron Rosenfeld

wrote:


--ron


Here's a VBA variant. It will parse the contents of "Selection" into the
cells
to the right:


I negelected to mention that you will need to set a reference in VBA

Select, from the main menu bar in the VB Editor:

Tools/References

Then SELECT Microsoft VBScript Regular Expressions 5.5


--ron