12-24-2011, 09:50 PM
12-26-2011, 11:25 AM
Arul,
Use below mentioned code.
Might be we will be having easy code also. But I know this code only.
Use below mentioned code.
Code:
str= "ADlanda"
n=len(str)
msgbox n
i=0
strRes=""
While i<n
a=mid(str,i+1,1)
If ASC(a)>=65 AND ASC(a)<=90 Then
strRes=strRes &a
End If
i=i+1
Wend
msgbox "Your Result is: " &strRes
Might be we will be having easy code also. But I know this code only.
12-27-2011, 11:11 PM
Hi kotaramamohana,
Thanks for ur script.
Regards,
Arul
Thanks for ur script.
Code:
str= "ADlanda"
n=len(str)
msgbox n
For i=0 to n-1
a=mid(str,i+1,1)
If ASC(a)>=65 AND ASC(a)<=90 Then
strRes=strRes &a
End If
Next
msgbox "Your Result is: " &strRes
Regards,
Arul