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.

How about just skipping the first character in your =hyperlink() formula:

=hyperlink(mid(a1,2,255))

(make that 255 large enough for any of your hyperlinks.)

===
Or if the # sign only appears in the first character in those strings, you
could:

Edit|Replace
what: #
with: (leave blank)
replace all


B.C.Lioness wrote:

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.

--

Dave Peterson

Thank You so much, the MID function worked perfectly! :)

"Dave Peterson" wrote:

How about just skipping the first character in your =hyperlink() formula:

=hyperlink(mid(a1,2,255))

(make that 255 large enough for any of your hyperlinks.)

===
Or if the # sign only appears in the first character in those strings, you
could:

Edit|Replace
what: #
with: (leave blank)
replace all


B.C.Lioness wrote:

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.

--

Dave Peterson