ma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Karan Singh
Sent: 05 October 2012 12:11
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Remove All Special Characters
Dear All,
I need to clean all special cha
Hi
In cell what input = removeSpecial(Cell) like this?
On 10/5/12, jeet singh wrote:
> Function removeSpecial(sInput As String) As String
> Dim sSpecialChars As String
> Dim i As Long
> sSpecialChars = "\/:*?"" {}[](),!`~\:;'._-=+&^%$<>|"
> For i = 1 To Len(sSpecialChars)
>
Function removeSpecial(sInput As String) As String
Dim sSpecialChars As String
Dim i As Long
sSpecialChars = "\/:*?"" {}[](),!`~\:;'._-=+&^%$<>|"
For i = 1 To Len(sSpecialChars)
sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), "")
Next
removeSpecial = sInput
End
Dear All,
I need to clean all special characters from a my data. Please suggest any
formula or macro to remove them.
Please find attached sheet.
Thanks
Karan Singh
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED f
