Thanks to everyone who replied on my request.
I received several solutions for my problem and the file works perfect now.
You were all very helpfull.
Thanks again!
On Wednesday, January 2, 2013 4:04:59 PM UTC+1, dannym...@gmail.com wrote:
> In excel 2012 I'm using the name typed in a cell as a
Hi Danny,
Just pass the name of file in belo metioned function it will remove all the
special charactor into the name
Function RemoveSpecialChrs(s As String) As String
Static RegEx As Object
If RegEx Is Nothing Then
Set RegEx = CreateObject("VBScript.RegExp")
With Re
Here's one way to do it in a formula: use this website ( ascii-code.com )
to look up the ASCII equivalent of each character. It turns out to be this:
/47
\92
*42
?63
"34
<60
>62
|124
Then use a FIND formula to look for the ASCII equivalent. I tried the
SEARCH form
