how do I convert text e-mail addresses in an Excel file to hyperli

[ben kottler]

new addresses that I type in are automatically converted, but ones I copied
into the spreadsheet are not. Any ideas welcome.

 

[David McRitchie]

Hi Ben,

Were they links where you copied them from.
What version of Excel are you using.

Does =LEN(A1) match the number of chars you actually see
and ="*" & A1 & "*" show anything resembling spaces

Does use of the the TrimALL macro fix them (make them links)
: http://www.mvps.org/dmcritchie/excel/join.htm#trimall