Hi all,



I'm here because I've never got around to mastering regular expressions/ wildcards.

I have a 3 column table containing address book data in Word. I'm trying to get them into an xml format.

1. Is there any expression that helps me do this when I do a search and replace? E.g. The cell contains XXX. I want to wrap XXX in <Name> XXX </Name>. What I need is an expression for the entire existing cell content, like replace "entire cell" with <Name> entire cell </Name>.

2. The cells in the 1st column contains data in this form - Alphabets [+Number].
How can I strip out the alphabets leaving just the [+Number]. Getting rid of the square brackets would be easy. It's the word(s) that are not encased in the square brackets that I want to get rid off.

3. The cells in the 3rd column contains data and time info in this form - 01-Jan 00:00 AM. I've no idea how to approach this one man. The end target is this form - 2010-01-01 00:00. The year for all the dates is the same.

If anyone can point the way, I'll really help.

Thanks,
Jay