I am importing an Access Query into a sheet of my Excel file. This query has
a column that is all hyperlinks. My problem is that instead of importing as
a hyperlink, it comes into Excel as plain text. I have used HYPERLINK(A1) to
try to convert, but there is a number sign (#) at the start of the plain
text. Is there a way I can delete this first character, then use
HYPERLINK(A1) to get my hyperlink into a column that is unaffected by data
updates?
I am using Access and Excel 2002, and I am pretty new to all this, I am
currently trying to wrap my brain around macros to see if I can find a
solution there, but that is confusing me more I think.
I will be grateful for any help.
Lori.
Bookmarks