Thanks But how this macro works
I want the difference in Cell c1 = where it is difference between A1 -B1
the data is in all cells -- that is from A1 TO A15 & B1 TO B15
SO how to copy this formula which is C1 -- TO C2 TO C15.
Tks
On Thu, Jul 8, 2010 at 10:04 AM, Soni.Rajender <soni.rajen...@gmail.com>wrote:
> 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 <bigsmile...@gmail.com> 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 excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> 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
>
--
----------------------------------------------------------------------------------
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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
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
1google.csv
Description: Binary data
