Ashish, You are doing such a tremendous job...Keep going Bro.
regards,
Mrinal
On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> March'11
> He has posted 48 posts in March 2011 and helped many people
Could you tell me what have you done ???
On Sun, Apr 3, 2011 at 8:42 PM, Jaideep Panchal wrote:
> if it helps...
--
Rakesh kumar khowal
+91 9868532105
--
--
Some important links for excel users:
1. Follow u
if your data in a1 type the below formula on anywhere in the same worksheet
=IF(AND(ISTEXT(A1),LEFT(A1,1)="0"),RIGHT(A1,LEN(A1)-1),A1)
--
*Thanks & Regards
Thamu
*
On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakash wrote:
> Guys thanks a ton for responses ,i need to remove only first letter in
then the macro should be modified like this
Sub RemoveLeadingZeros()
Dim xCell As Range, i As Integer, s As String
For Each xCell In ActiveSheet.UsedRange
s = CStr(xCell)
For i = 1 To Len(xCell)
If Mid(xCell, i, 1) = "0" Then
s = Right(s, Len(s) - 1)
try this made some changes in the code
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In ActiveSheet.UsedRange
If Left(xCell.Value, 1) = 0 Then
xCell.Value = Right(xCell.Value, Len(xCell.Value) - 1)
End If
Next
End Sub
On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakas
Guys thanks a ton for responses ,i need to remove only first letter in
cell if it is zero in alpha numeric data - regards - bhanu
On 04-Apr-2011 3:45 AM, "STDEV(i)" wrote:
run this macro
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In ActiveSheet.UsedRange
xCell = Replac
Thank you!:-)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, March 29, 2011 10:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint )
VBA
Hi all
To learn ad
Hi Bhanu,
Select all the cells where you want to remove zeros and select control + H,
and type 0 and replace with blank and then click on* Replace All.*
*
*
*
*
Thank you,
Shreedar
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote:
> Hi - need it help excel. Removing zeros in alpha numeric da
Congrats Ashish. Go ahead.
Regards,
Dhananjay
On Sun, Apr 3, 2011 at 4:08 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Congratulations Ashish….
>
>
>
> You are simply amazing… thanks for the tips and hats off to you for your
> excel knowledge….
>
>
>
> I really amazed with ho
u can use the following formula
=SUBSTITUTE(A1,0,"")
(where Cell A1 is target data)
Regards,
Dhananjay
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote:
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhan
Hi,
Pls find attached file & let me know if it serve the purpose.
Regards,
C.G.KUMAR
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad wrote:
> Hi Team / Ayush,
>
> Need a formula about a countif criteria
>
> See the attachment and please do the need full
>
> Regards
> prasad
>
> --
>
>
Hi
Use
=SUBSTITUTE(A1,"0","")
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote:
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
Please attach file, so see what you need
I answer for what you need
2011/4/3 Jaideep Panchal
> Hi Group,
>
> I joined this group few months ago and I find it very helpful, I would like
> to thank its group Mgr.
>
> In my org, attendance cycle is 21th to 20th of next month but we need MTD
> atte
Please attach file, so see what you need
There are many ways, row or column or range
I answer what you need to pair
2011/4/3 bhanu prakash
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
>
run this macro
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In ActiveSheet.UsedRange
xCell = Replace(xCell, "0", "")
Next
End Sub
since you ask for "REMOVING ZERO IN EVERY CELL"
1500 will be 15
2100500 will be 215
and so on
On Sun, Apr 3, 2011 at 9:55 PM, bhanu pr
Hi Group,
I joined this group few months ago and I find it very helpful, I would like to
thank its group Mgr.
In my org, attendance cycle is 21th to 20th of next month but we need MTD
attendance for few reports. I am attaching a sample sheet, can someone provide
a macro or pivot table if its p
Hi Rakesh,
See if it helps...
Regards,
Jaideep Panchal
New Delhi
- Original Message -
From: rakesh kumar
To: excel-macros@googlegroups.com
Sent: Sunday, April 03, 2011 1:44 PM
Subject: Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Umesh/Group members,
I
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell. Regards ,- bhanu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips trick
Hi Experts,
i got a assigment to write a macro which will capture time by each agents
along with their work assign to them.please find attached sheet for
refrence.its very important
for me.please help me out.
Thanks,
Prabhat
--
Hi Experts,
i got a assigment to write a macro which will capture time by each agents
along with their work assign to them.please find attached sheet for
refrence.its very important
for me.please help me out.
Thanks,
Prabhat
--
Congratulations Ashish
You are simply amazing... thanks for the tips and hats off to you for your
excel knowledge
I really amazed with how quickly you can answer the queries of forum with such
a difficult VBA code...
Ayush
On breaking of the records I believe Dave Bonallack & Pau
Hi prasad,
Good day to you!
Attached is the solution. Please have a look and let me know if any
further assistance is required.
Regards
Ayush Jain
Group Manager
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad wrote:
> Hi Team / Ayush,
>
> Need a formula about a countif criteria
>
> See the attachm
see if it helps
SUMPRODUCT((List!$A$1:$A$16=Sheet1!$A2)*(List!$B$1:$B$16=Sheet1!B$1))
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad wrote:
> Hi Team / Ayush,
>
> Need a formula about a countif criteria
>
> See the attachment and please do the need full
>
> Regards
> prasad
>
> --
>
>
Hi Umesh/Group members,
I am attaching the sample data. I know if I take gender for column it'll
solve the problem, but for some reason I don't wish to add any field in the
column..
Thanks !
On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev wrote:
> Hi Rakesh,
>
> can you attach the excel sheet
>
>
Hi Team / Ayush,
Need a formula about a countif criteria
See the attachment and please do the need full
Regards
prasad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
25 matches
Mail list logo
