From: Lucky on 16 Jan 2010 09:17 Many thanks to everyone. I ended up using Gary"s procedure, converting it into a function. Now I'll just stick the function in my module, send it the contents of each cell in the column, and replace the contents with the results of the function. Works great! I want to experiment with all 3 solutions because they all contain interesting concepts that are new to me. I really appreciate the help. Lucky |