Need help on Hyperlink creation in Excel

[@Kumar157@]

Hi All,

I have an URL www.google.co.in in cell A1 and text Google in cell A2.
Now, I would like to make cell A3 with a text in A2 and hyperlink in A1.

I have a big list like this to do it manually, I want a formula for this.

 

[Khalid NGO]

Hi Kumar,

Have you tried Hyperlink formula? it allows us make a friendly name too.
=HYPERLINK(A1,A2)

Regards,