hi
can you please give ma codes which will remove the unwated or_ at the
end of emailds in attachment
thanks
ashish
--~--~-~--~~~---~--~~
--
Some important links for excel
Just added some lines to Daniel's code.
See attached file...
On Mon, Sep 7, 2009 at 11:34 AM, ashish koul koul.ash...@gmail.com wrote:
hi
can you please give ma codes which will remove the unwated or_ at the
end of emailds in attachment
thanks
ashish
--
Thanks
*Sorry, attached wrong file**try the attached file.*
On Mon, Sep 7, 2009 at 2:27 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Just added some lines to Daniel's code.
See attached file...
On Mon, Sep 7, 2009 at 11:34 AM, ashish koul koul.ash...@gmail.comwrote:
Hi.
Can you attach a sample file to your reply ?
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ashish koul
Sent: dimanche 6 septembre 2009 18:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: help plz
hi thanks
i
Hi,
See attached file. Select the range of mail addresses and execute the test
macro.
HTH
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ashish koul
Sent: lundi 7 septembre 2009 08:05
To: excel-macros@googlegroups.com
Subject:
Hi ,
Attached file is donloaded from RBI.
1I found date in dd/mm/ format But when I am converting it in date
format is not converting
How I can I do that?
2 issue no.2 not related to this
last time I dump data date format was in mmddyy but I have to convert by
using F2
Hi.
I have been using Excel for years but never really needed to get into
VBA too much .. usually recording the macro was sufficientbut now
I am learning VBA as I go.
I want to know if there is a command which will allow me to all sheets
in a workbook at the same time.
I want to enter text
Thanks got solution !
On Mon, Sep 7, 2009 at 4:49 PM, Umakant Hale umakant.h...@gmail.com wrote:
Dear dilip,
here source sheet 1,2,3, 4, 5... it is any random no, i don't want to put
A2=1 or A2=2 like this format, colomn a A includes any Random No. or Any
name,
pls give solution.
Hi Ashish,
Use following formula to remove whitespace.
=SUBSTITUTE(B2, , )
Regards,
Swapnil.
On Sun, Sep 6, 2009 at 9:29 PM, ashish koul koul.ash...@gmail.com wrote:
hi thanks
i went through the site i am able to clean and trim but in below case i am
not abe to find the solution
Hi all,
I'm using Excel 2003 and I'm writing a simple VBA application which
inserts single credit card expenses into a sheet and then updates - in
the same sheet but in a different area - the total on a month basis.
I have some problems in the month basis update because dates aren't
managed
Hi,
Use the Concatenate Function.
ashish k...@gmail.com ashish k...@gmail.com
If the data is in cells A1 and B1, then put concatenate(A1,B1) in cell C1
Regards,
Swanand Deshpande
From: Daniel
Sent: Monday, September 07, 2009 3:42 PM
To: excel-macros@googlegroups.com
Subject:
Good morning!
Would love your help with this issue. I'm try to create a formula that
will evaluate a number based on whether it fits into one of five
buckets and then apply the appropriate formula to calculate the
resulting credit value I'm seeking.
N = The number being evaluated (referred to
Hi
I have names on a column of an XL sheet e.g.
Bharti
Russel
X..
Y..
Z...
etc
I wish to (a) insert new sheets and (b) name these sheets Bharti,
Russel etc etc i.e. new sheets to be inserted and named as per date on
the column
Any help / pointers would be most appreciated
Thanks in advance
Sub test()
Dim c As Range
Dim x As Integer
For Each c In Selection
If c.Value Then
c.Value = Application.Clean(c.Value)
c.Value = Application.Trim(c.Value)
c.Value = Application.Substitute(c.Value, , )
c.Value = LCase(c.Value)
hi
thanks harmeet
but in this case it only works with emailids ending with .com wht if iit
ends with .net or .org or .in
On Mon, Sep 7, 2009 at 6:12 AM, Daniel dcolarde...@free.fr wrote:
Hi.
Can you attach a sample file to your reply ?
Daniel
*From:*
Dear dilip,
here source sheet 1,2,3, 4, 5... it is any random no, i don't want to put
A2=1 or A2=2 like this format, colomn a A includes any Random No. or Any
name,
pls give solution.
Umakant
-- Forwarded message --
From: Dilip Pandey dilipan...@gmail.com
Date: Sat, Sep 5, 2009
Thank you everyone for your suggestions. I'd have to say that of all
the submissions, Daniel's is the one that really seems to have nailed
it. He correctly understood that simply subtracting the begin year
from the current year and dividing this number by the number of years
in the contract term
You can select the first sheet tab, hold the shift key then select the last
sheet tab.
This will activate all sheets.
Enter the desird content of the any cell
On Mon, Sep 7, 2009 at 5:53 AM, rmullan mullanr...@hotmail.com wrote:
Hi.
I have been using Excel for years but never really needed
then use this file...
On Mon, Sep 7, 2009 at 3:54 PM, ashish koul koul.ash...@gmail.com wrote:
hi
thanks harmeet
but in this case it only works with emailids ending with .com wht if iit
ends with .net or .org or .in
On Mon, Sep 7, 2009 at 6:12 AM, Daniel
*Dear Prashant All Group Member*
Thanks for showing interest to solve my problem,
Attaching sample zip file containing
1. Master 1
2. Master 2
Now i wish any macro to create Final Master file. Please check for desire
output file.
I will be really grateful for all of you if you provide
Hi Mark,
Your description is very detailed, but I still get lost in it. Perhaps you
could attach the file. Fudge the data if it's sensitive.
Regards - Dave.
Date: Mon, 7 Sep 2009 06:37:32 -0700
Subject: $$Excel-Macros$$ Too many arguments for this function help with
nested IF statements
Hi All,
This is challenge for all excel users. Solve these puzzles and sharpen your
excel acumen. So, here goes the second puzzle of Excel Macros Google Group
in the attached file.
*Old Puzzles:*
Puzzle #1 -
22 matches
Mail list logo
