Hi
Please find the code below.
Sub test()
Dim one As String
Dim two As String
Dim three As String
Dim four As String
one = Range("a1")
two = Range("b1")
Range("c1").Value = ""
For x = 1 To 10
If Mid(one, x, 1) = Mid(two, x, 1) Then
Else
Range("c1") = Range("c1").Value & Mid(one, x, 1)
End If
Next
End Sub
Regards
Rajender Soni
On Jul 6, 7:56 pm, big smile <[email protected]> wrote:
> Hello Friends
>
> I want to know that can it possible the following idea.
>
> Cell A1 contains text ---->>> Shri Ram Chandra
>
> Cell B1 contains text ----- >>> Shri RAM cHANDRAs
>
> I want to that i want the formula in C1 --
> which give me the result of that difference between this A1 & B1
> the answer is only last word - S
>
> BUT
> 1] The difference of Capital Letter & Small letter can be point out.
>
> 2] The space should not be taken into account
>
> 3] The cell may also contain - both text & number also like BHCD 1234 DELETE
>
> Can it possible if yes by witch formula ?
>
> Have a nice day
>
> Thanks
> Savla
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
