X

Excel Me Remove Numeric Macro Ka Use Kaise Kare

Hello friends, aaj hum excel me remove numeric macro ka use kaise karte hai, iske bare me janenge, aap shayad ye jaante honge ki Microsoft Excel me VBA ek Excel Programming language ya tool hai. Ye tool microsoft dwara develop ki gayi hai aur iski help se excel worksheet me programs ko develop kiya jaata hai.
Aap jaante honge ki log excel ka use hazaro alag alag work ke liye karte hai, aur unn sabhi task ko excel macro ki help se easy bana sakte hai jinme se kuch examples niche diye gaye hai.
  • Products & Customer Names List
  • Student Name, Student Grades & Student Total Marks List
  • Budget list, Forecasting List
  • Scientif Data Analysis
  • Chart Ka Use
  • Forms & invoice creation Etc

 

Excel Me Remove Numeric Macro Ka Use Kaise Kare

Aaj ki post me aapko ek esi useful macros (VBA trick) ke baare me jaankari di jaayegi jiski help se aap excel worksheet ke cells me ek saath mojud text aur numeric ke beech me se numeric digits ko remove kar sakte hai, to chaliye dosto step by step dekhte is Macro Tutorial me ki kaise karna hai.

Step 1

Sabse pehle ek worksheet open kare aur usme ek list banaye, name ke saath numeric ki. Aap chahe to dono ke beech me space de ya phir without space rehne de.

 

 

Step 2

Ab niche diye step follow kare.

  1. List ko select kare.
  2. VIEW tab me click karke macro > view macro par click kare ya phir Alt+F8 kare.
  3. Macro name de, kuch bhi de sakte hai. Fox expl:- ABC.
  4. Create ki button par click kare.

 

Step 3

Ab aapke samne ek code module box open hoga isme pehle se jo text honge unko delete kar de aur niche di gayi macro command ko copy kare.

  1. Niche box me diya gaya macro code copy karke yaha paste kare.
  2. Play ki button par click kare.

 

Sub RemoveNum()
‘Updateby20131129
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = “KutoolsforExcel”
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox(“Range”, xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
xOut = “”
For i = 1 To Len(Rng.Value)
xTemp = Mid(Rng.Value, i, 1)
If xTemp Like “[0-9.]” Then
xStr = “”
Else
xStr = xTemp
End If
xOut = xOut & xStr
Next i
Rng.Value = xOut
Next
End Sub

 

 

Step 4

Iske baad ek Kutools box open hoga.

  1. Apni list ko select kare.
  2. Ok ki button par click kare.

 

Ab jaise hi aap ok button par click karenge, aapki alpha aur numeric list me se numbers remove ho jayenge, niche image me dekhe.

 

Ye Bhi Padhe

 

Dosto ummeed hai aapko yeh post pasand aayi hogi,  agar kisi tarah ka koi confusion hai to aap comment karke apna saval puch sakte hai, hume reply karne me khushi hogi.

Agar remove numeric macro se related ye post aapko acchi lagi ho to isse social networking sites par apne dosto ke sath share bhi jarur 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

View Comments (1)