Newbie problems...


Hi all, I've been scouring the web for two things and I'm coming up empty. If this has already been asked I apologize and if someone could point me to the link I'd appreciate it.
I want to change the format of a date in a word document to a "long date" e.g., January 15, 2013 and in that same document convert an SSN w/o dashes to one with dashes. Both the dates and SSNs will vary from document to document.

Date Issue
In the documents I'm given there are two date ranges (which will be different in every document) given:

1. "between 01/15/2010-06/12/2011"

and

2. "of 01/15/2010-06/12/2011"

Both sets of dates would need to read "January 15, 2010" and/or "June 12, 2011". However, for the first example the hypen should be changed to "and" and in the second example the hyphen should be changed to "through".

SSN Issue
Throughout the same documents there are SSNs without dashes. They appear as either SSN: ######### OR SSN #########. There are other numbers in the document which are 9 digit numerics so I need the search parameters to include the "SSN" and "SSN: ".

Is there a way to insert the dashes with a macro? 123456789 to 123-45-6789? I would think I could search for "#########" and change it to "###-##-####" but my google searching was fruitless.

I probably won't be able to repay all you VBA masters anytime soon but I'm not above cookie bribery .
Thank you in advance for your time!