Can you send me a sample of your data?

It doesn't have to be the whole workbook. You said you have the address in a
few columns, maybe just copy some of that data to a single sheet and send me
that sheet. Everything I suggested I tested in MY test sheet but it's not
YOUR sheet!

If you can do that I'll have a better idea of what you need.

Here's where you can contact me:

xl is no help at comcast period net

Get rid of "is no" and change the obvious.

Biff

"gbeard" wrote in message
om...
Biff,
When do you enter a formula as an array as opposed to just hitting RETURN?
I just entered the last string as an array and get a #VALUE! error.

BTW, I do love this. I've been working with Excel for years and just
started using this NG a couple of weeks ago. I'm amazed at how much I've
learned in the last couple of weeks thanks to this NG.

--
Gary Beard