HYPERLINK TEXT MICRO

Hello friends agar aap excel worksheet me websites se copy kiya hua data use karke formating aur editing karte hai to yeh post aapke liye hi hai.

EXCEL START KAISE KARE

About Hyperlink

Hyperlinks jyadatar website ke under tabs me, individual name aur email ko touch karke dekh sakte hai aur jaise hi hum links ko mouse se click karte hai to ye hume ek naye link me pahucha deta hai, agar link me website ka url set hai to website open hogi aur agar email address set hai to email box open ho jaata hai.

Hyperlink Se URL Ko Kaise Extract Kare

Hyperlink se URL (address) ko aap do tarike se copy aur extract kar sakte hai:-

DATA GROUP KE BAARE ME JAANE

1. Manual Tarike Se

1. Hyperlin par right click kare.
2. Menu se edit hyperlink pe click kare.
3. Ab jo dialog box open hua hai usme se URL select karke copy kare aur Esc button press kare box ko close karne ke liye.
4. Iske baad excel worksheed me kisi bhi cell me paste kar sakte hai.
Dosto manual tarika hum kuch hi url’s ko extract karne ke liye kar sakte hai lekin tab kya kare jab aapko ek badi list ko extract karna pade?? Iske liye dusra tarika hai micro ka use.

FORMULA TEXT KE BAARE ME JANE

2. Use Micro

Step 1

Sabse pehle new worksheet open kare aur usme link ki list ko pest kare.

DATA SORT & FILTER KI JAANKARI 

Step 2

1. View tab me > micro > view micro par click kare ya Alt+F8 shorcut bhi use kar sakte hai.
2. Micro name me koi bhi name de sakte hai.
3. Create button par click kar de.

Step 3

1. Cntrl+A karke pehle se avalable code ko delete kar de.
2. Neeche diya gaya code copy kare aur pest kare.

Function HyperLinkText(pRange As Range) As String

Dim ST1 As String
Dim ST2 As String

If pRange.Hyperlinks.Count = 0 Then
   Exit Function
End If

ST1 = pRange.Hyperlinks(1).Address
ST2 = pRange.Hyperlinks(1).SubAddress

If ST2 <> “” Then
   ST1 = “[” & ST1 & “]” & ST2
End If

HyperLinkText = ST1

End Function

Step 4

Iske baad Alt+Tab karke wapas apni worksheet me jaye aur link list ke agle column me yeh formula lagaye:-

1. Yaha par formula lagaye  =HYPERLINKTEXT(A1)
2. Ab B1 se formula copy kare aur niche sabhi links ke aage pest kar de.

FACEBOOK EARNING KAISE KARE

Step 5

Ab aap dekh sakte hai ki aapki link list ke under kaun kaun se url (website link) hai aur sath hi sath inn links ko kahi bhi copy, cut aur pest bhi kar sakte hai.

Dosto iss post me hyperlink text ki jaankari share ki share ki hai, agar aapko pasand aayi ho to share jaroo kare.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

4 thoughts on “HYPERLINK TEXT MICRO

Leave a Reply

Your email address will not be published. Required fields are marked *