For the record, I received a PM from austenr as follows:

Quote Originally Posted by austenr
So the way you rearranged the code will work? Just need to know when the box comes up to ask what you want to delimit it with what you type in and the correct format.

ex. comma , or "comma" or ",". Currently it is putting every cell in one cell instead of breaking up the name in one, SS# in another etc.

Thanks in advance for your help.
and my reply:
Quote Originally Posted by mvidas
Hi austenr,

In the fix I posted (my original post was just to make your code readable), you would enter "," (no quotes) in the input box.

Also, in the message itself is a reply box at the bottom. Please put questions like this in there so people can read your responses/questions. Theres no need to add extra questions for things like this, when you can just simply reply to existing questions.

Should you have any questions about how to use this forum, please don't hesitate to ask!
Matt