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

Hi,

While you are on cell A1, hit Ctrl+K to create a hyperlink to the required
sheet. You would have to do this for the entries in column A

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pai" wrote in message
...
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

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

i mean to say that whenever we entered any function say 1+2 is =3 then we are
convert into value by Copy<paste Special<value.

Is there any way to convert hyperlink function into Hyperlink

I have More than 80 to 90 Sheets in a workbook And i have 20 workbooks.

Thanks

Pai
"Ashish Mathur" wrote:

Hi,

While you are on cell A1, hit Ctrl+K to create a hyperlink to the required
sheet. You would have to do this for the entries in column A

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pai" wrote in message
...
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

As i mention that this function is perfectly working for me.

If other Formulas are convert into Value why not Hyperlink function.

Say that i have list of name in A1 I put this Function in B1, but when i
Delete the entire Column A1 it will Show only 0 in B1. I want to Delete
Column A which have NAME.

Is it possible to Delete ColumnA with effecting any Hyperlinks in B1

Or is there is any method without doing Manually and USING MACRO to inset
hyperlinks.


Thanks

Pai


"Pete_UK" wrote:

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