Convert hyperlink function into hyperlink

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
 
A

Ashish Mathur

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
 
P

Pete_UK

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
 
H

Hardeep_kanwar

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 said:
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 said:
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
 
H

Hardeep_kanwar

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 said:
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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top