Paste hyperlink formula as values with link

[sridhar_shri03]

Hi,

I have a hyperlink formula in column C & D, i just want to paste these formulas as values with link. In short, i want to remove hyperlink formula but not the link associated to that cell.

Please help

Thanks
Sridhar

 

[ThrottleWorks]

Hi @sridhar_shri03 , sorry I did not understand your question correctly.

Will doing a Paste Special help ? Is it possible for you to upload a sample file.

 

[sridhar_shri03]

Hi,

sorry for that, To be clear i have used Hyperlink(Vlookup(Link), Vlookup(Friendly name)) in Column C & D to get a link from another sheet, now i want this result without formula, i want to submit a final report file without formula but with links. I tried paste special options but the hyperlink is not working. is there a option to remove formulas but keeping links here.

Please help

Regards
Sridhar

 

[sridhar_shri03]

Hi Can you please help ...

 

[Deepak]

Can we have the sample xl with expected out pls.

 

[Chihiro]

One way to do it is to copy and paste out to Word Doc.
And then copy and paste back from Word Doc to Excel. This will retain link and title/friendly name.