P
Pai
I am using hyperlink function using excel 2003. I type this
function in CellA it works perfectly e.g.
HYPERLINK("[Book2.xls]" & A2 & "!" & "a1 ", A2)
But It show in the Form of Formulas. I want In the simple Hyperlink format
My data is look like this After insert the Hyperlink Function
Name
aaryan
aditya
hardeep
neeraj
pai
pardeep
renu
Before
A1 B1
aditya HYPERLINK("[Book2.xls]" & B32 & "!" & "a1 ", B32)
hardeep HYPERLINK("[Book2.xls]" & B32 & "!" & "a1 ", B32)
neeraj HYPERLINK("[Book2.xls]" & B33 & "!" & "a1 ", B33)
pai HYPERLINK("[Book2.xls]" & B34 & "!" & "a1 ", B34)
pardeep HYPERLINK("[Book2.xls]" & B35 & "!" & "a1 ", B35)
renu HYPERLINK("[Book2.xls]" & B36 & "!" & "a1 ", B36)
How can I Convert this in the fom of Hyperlink and remove this function
before I have only one column,now after inserting the function I have 2
column
I want only one column
Thanks
Pai
function in CellA it works perfectly e.g.
HYPERLINK("[Book2.xls]" & A2 & "!" & "a1 ", A2)
But It show in the Form of Formulas. I want In the simple Hyperlink format
My data is look like this After insert the Hyperlink Function
Name
aaryan
aditya
hardeep
neeraj
pai
pardeep
renu
Before
A1 B1
aditya HYPERLINK("[Book2.xls]" & B32 & "!" & "a1 ", B32)
hardeep HYPERLINK("[Book2.xls]" & B32 & "!" & "a1 ", B32)
neeraj HYPERLINK("[Book2.xls]" & B33 & "!" & "a1 ", B33)
pai HYPERLINK("[Book2.xls]" & B34 & "!" & "a1 ", B34)
pardeep HYPERLINK("[Book2.xls]" & B35 & "!" & "a1 ", B35)
renu HYPERLINK("[Book2.xls]" & B36 & "!" & "a1 ", B36)
How can I Convert this in the fom of Hyperlink and remove this function
before I have only one column,now after inserting the function I have 2
column
I want only one column
Thanks
Pai