ADVANCE EXCEL

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.

Remove Numeric Macro

 

 

Step 2

Ab niche diye step follow kare.

Remove Numeric Macro

  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.

Remove Numeric Macro

  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.

Remove Numeric Macro

  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.

Remove Numeric Macro

 

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

One thought on “Excel Me Remove Numeric Macro Ka Use Kaise Kare

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.