Subject: »MS Excel & Word tips, and tricks

Hi, is here any excel master? I need help.

and the problem is?

---

---

---

---

---

Topic reopened, those who spam will be punished.

Please stick to the topic, more exactly questions about Excel and Word programs and consequent explanation if requested.

P.S. Thank you for understanding.
(edited)

If I have a hyperlink in MS excel in cell A1 and I want to get to cell B1 URL of the hyperlink and to C1 name of the hyperlink, how can I do that?
(edited)

I'm no genius with Excel, but most answers can most of the times easily be found with the help of Google.

Maybe this is what you are looking for?

contextures.com - Create a Hyperlink with a Formula

techonthenet.com - Create a hyperlink to another cell

I don't get what you want (and I do know how to make hyperlinks in Excel).

You can copy the hyperlink and then use Paste special feature.

For the url use paste special->operation->multiply
for the name use paste special->values

simple as that.

works for multiple urls aswell.
(edited)