How to Remove Text from cell in Excel Quickly VBA

Опубликовано: 24 Февраль 2021
на канале: Excel Advisor

2,701

In this video you will learn how to Remove Text from cell in Excel Quickly VBA!
VBA CODE:
Sub Remove_Text_From_Cells()

'Removes text from cells.
'Will not remove any characters other than text

Dim rngCell As Range
Dim intChar As Integer
Dim strCheckString As String
Dim strCheckChar As String
Dim intCheckChar As Integer
Dim strClean As String

For Each rngCell In Selection
strCheckString = rngCell.Value
strClean = ""

For intChar = 1 To Len(strCheckString)
strCheckChar = Mid(strCheckString, intChar, 1)
intCheckChar = Asc(strCheckChar)
Select Case intCheckChar
Case 65 To 90
Case 97 To 122
Case 128 To 151
Case 153 To 154
Case 159 To 165
Case Else
strClean = strClean & strCheckChar
End Select

Next intChar
rngCell.Value = strClean

Next rngCell

End Sub
______________________________

How to Add Items in Rows from Dropdown list Automatically-VBA
   • How to Add Items in Rows from Dropdow...

How to Add Items in Columns from Dropdown list Automatically- VBA
   • How to Add Items in Columns from Drop...

How to Populate other Cell Based on Dropdown list Automatically - Urdu | Hindi
   • How to Populate other Cell Based on D...

How to Select Multiple Values from drop down list in Excel (VBA) - Hindi | Urdu
   • How to Select Multiple Values from dr...

Create Multiple Dynamic Dropdown List in Excel
   • Create Multiple Dynamic Dropdown List...

Automatic Data Formatting Feature in Excel (VBA) - Urdu | Hindi
   • Automatic Data Formatting Feature in ...

Hide Excel Worksheet in Smart Way - Urdu | Hindi
   • Hide Excel Worksheet in Smart Way - U...

How to Paste on Filtered Cells in Excel - Hindi | Urdu
   • How to Paste on Filtered Cells in Exc...

Top 70 Excel Shortcut Keys - Improve your Excel skills
   • Top 70 Excel Shortcut Keys - Improve ...

Sum & Count by Cell Color in Excel - Urdu | Hindi
   • Sum & Count by Cell Color in Excel - ...

Vlookup by cell color in excel - Hindi / Urdu
   • Vlookup by cell color in excel - Hind...

How to Split Data into Multiple Workbooks - Urdu/Hindi
   • How to Split Data into Multiple Workb...

Merge List of Values into Single Cell in Excel - Urdu/ Hindi
   • Merge List of Values into Single Cell...

How to Extract Comments from Cells in Excel - Urdu / Hindi
   • How to Extract Comments from Cells in...

How to Count Unique & Duplicate Values in Excel - Urdu / Hindi
   • How to Count Unique & Duplicate Value...

Copy Content Format, Formula & Text across Worksheet in Excel
   • Copy Content | Format | Formula | Tex...

Double Vlookup | Get Data from Multiple Workbooks
   • Double Vlookup in Excel | Get Data fr...

Advance Subtotal & Total in Excel | Hindi / Urdu
   • Advance Subtotal & Total in Excel | H...

COUNTIFS & SUMIFS | Calculate Monthly, Quarterly, Yearly | Hindi /Urdu
   • COUNTIFS & SUMIFS | Calculate Monthly...

Flash Fill in Excel (Save your time)
   • How to use Flash Fill Function in Excel

Create Table of Content
https://www.youtube.com/watch?v=2BJdP...

Index Match - Find Multiple Matches
   • Index Match - Find Multiple Matches

Merge Data from Multiple sheets into single sheet
https://www.youtube.com/watch?v=bREsv...

Excel Top 5 Formula:
https://www.youtube.com/watch?v=JXqEW...

How to break Excel Workbook Password:
https://www.youtube.com/watch?v=lY1IJ...

Import Multiple Files from folder into Single Excel Sheet:
https://www.youtube.com/watch?v=mE2Qk...

How to Clean all type of errors, spaces, bugs etc. in excel:
https://www.youtube.com/watch?v=DCy4M...