You need to put an equals sign in front of your formula:

=HYPERLINK("[Book2.xls]" & A2 & "!" & "a1 ", A2)

and then copy it down.

If it is still showing the formula rather than the result, then the
cell is formatted as text. Use Format | Cells | Number tab, and choose
General then OK. Then press F2 on the cell, followed by <Enter to
effect the change of format.

Hope this helps.

Pete

On Nov 10, 7:02*am, Pai wrote:
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