Are you usng Excel XP? I thought it recognised e-mail address's and created
the hyperlink automatically?

to add a space, I'd add another column ad concatenate a space on the end=

(if you're e-mail address's are in col D)

=D1&" "

and use that.

Matt



"Sumac" wrote:

I import data as a delimited file. One column is e-mail address. We would
like to have it in Excel as mail hyperlink. You seem to be able to do that
by adding one space after each address, but we have hundreds. Can I do that
for all addresses at the same time?