Dear Noorin,
Your VBA Solution is Good.But I ask you if we use UDF VBA code then how to
know what type words write in cell to extract output.which Code you
provide,I put in model & come in excel then next stage I dont know what
words type in cell to extract output from VBA code.
So pls Guide me,h
nooran ji good one thanks
On Mon, Feb 25, 2013 at 1:44 PM, NOORAIN ANSARI wrote:
> Dear Harkesh,
>
> Please try it..
>
>
> Function special_Charcters(rng As Excel.Range)
> Dim i As Integer
> Dim j As Integer
> For i = 1 To Len(rng)
> If Not Mid(rng, i, 1) Like "[0-9,A-Z,a-z]" Then
> special_Char
Dear Harkesh,
Please try it..
Function special_Charcters(rng As Excel.Range)
Dim i As Integer
Dim j As Integer
For i = 1 To Len(rng)
If Not Mid(rng, i, 1) Like "[0-9,A-Z,a-z]" Then
special_Charcters = special_Charcters & Mid(rng, i, 1)
End If
Next i
End Function
Function Only_Numbers(rng As
Dear Harkesh,
If you need a specific solution for your assignment or given data you can
consider attached file else look in to the solution given by kuldeep.
Rgds,
On Fri, Feb 22, 2013 at 10:14 PM, Harkesh Kumar
wrote:
>
>
>
> Please solve this Problem
>
>
>
> Please Seperate Special character
Assuming the first value is in A2
In B2 put =left(A2,1)
In C2 put =mid(A2,2,4)
Drag these formulas down.
Regards
David Grugeon
On 23 February 2013 16:14, Harkesh Kumar wrote:
>
>
>
> Please solve this Problem
>
>
>
> Please Seperate Special character and number
>
> num
>
> Ans
>
> @1234
>
>
tt.net'
Subject: $$Excel-Macros$$ Assignment or examples
Dear Expert,
I'm keen to learn many things on excel but I don't have proper guide line like
assignment or example to work out.
Can you please provide if you have anything's. So that I can improv
Dear Expert,
I'm keen to learn many things on excel but I don't have proper guide line like
assignment or example to work out.
Can you please provide if you have anything's. So that I can improve my excel
skill
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT
