Hi Anil
Perhaps u can try this as well
Sub Mtest()
Dim rng As Range, c As Range
Dim i As Long
Set rng = Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
For i = 65 To 90
For Each c In rng
If Not IsEmpty(c) Then
c.Replace Chr(43), ""
c.Replace Chr(i), ""
Thanks rajan and viper I will try
Anil
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be ans
You can use text to column , provide + as a delimiter
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Apr/Sat/2012 10:52
To: excel-macros
Subject: Re: $$Excel-Macros$$ NEED SOME ATT.
On Sat, Apr 7, 2012 at 10:50 AM
in b2 =--LEFT(A2,FIND("+",A2)-1)
in c2 =IF(ISNUMBER(--(A2)),0,RIGHT(A2,LEN(A2)-FIND("+",A2)))
or =iferror(RIGHT(A2,LEN(A2)-FIND("+",A2)),0)
On Sat, Apr 7, 2012 at 10:51 AM, anil kumar wrote:
>
>
> On Sat, Apr 7, 2012 at 10:50 AM, anil kumar wrote:
>
>> Hi Friends,
>>
>> can anybody solve th
On Sat, Apr 7, 2012 at 10:50 AM, anil kumar wrote:
> Hi Friends,
>
> can anybody solve this problem. sample file attached.
>
>
>
> Thanks & Regards
>
> Anil
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
Hi Friends,
can anybody solve this problem. sample file attached.
Thanks & Regards
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
