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),
End
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
On Sat, Apr 7, 2012 at 10:50 AM, anil kumar kmr7a...@gmail.com 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
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 kmr7a...@gmail.com wrote:
On Sat, Apr 7, 2012 at 10:50 AM, anil kumar kmr7a...@gmail.com wrote:
Hi Friends,
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
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