Sunday, 12 May 2019

Remove special characters from Text Data in Excel



 There are following steps perform:

Step 1: Open excel file that have data.
Step 2: Press on Keyboard ALT+F11

Step3: Now, You can see new window.
Step4: Go on Insert-Module.
Step5: Copy and Paste below code on Module1 form.
 
Function Remove(Str As String) As String
 'UPDATE BY ITSolution44U
  Dim xChars As String
  Dim I As Long
  xChars = "/.',#$%@!()^*&\-+*"
  For I = 1 To Len(xChars)
  Str = Replace$(Str, Mid$(xChars, I, 1), "")
  Next
  Remove = Str
End Function

Step6: Then save and exit.
Step7: Now, You can get new function 'remove'
           It's use like as =remove(a1)

 




How to Bypass Microsoft Account Sign-in and Setup Windows 11 without Internet - ITSolution4U

We are facing problems in insert or embed an Outlook mail with Symbol in Excel. So, How to resolve it? You can see below image that you will...