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 users
*Created a tool.
*See attached file..
On Sun, Sep 6, 2009 at 11:10 PM, mykijune wrote:
>
> How can I create multiple new files using data from excel? For
> example:
>
> A1=ProductName1 B2=Productdescription1
> A2=ProductName2 B2=Productdescription2
>
> Etc..
>
> To:
>
> productname1.txt (con
Thanx man,
u all ppls are just awesome.
double thumbs up for u ..
On Sun, Sep 6, 2009 at 2:43 PM, jonell wrote:
> On Sep 5, 5:07 pm, Mahesh wrote:
> > Dear Firends,
> >
> > need ur help here.
> >
> > i want to enter number in sheet 2 and want to match it in sheet 1
> > if the same numbe
Dear Ayush and Ashish,
Congratulations to both of you and thank you for creating this
wonderful forum to learn excel from the masters in this group.
Thanks
Ashish
On 9/6/09, Ayush wrote:
>
> Dear Members,
>
> Finally With all your support and good wishes we have completed 6000
> Members in o
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
ashish k...@gmail.com. result should be ashishk...@gmail.com
koulashish @gmail.com...result should be koulash...@gmail.com
koul.ashish @gmail.com result should be kou
*Created a tool.**See attached file..*
On Sun, Sep 6, 2009 at 11:10 PM, mykijune wrote:
>
> How can I create multiple new files using data from excel? For
> example:
>
> A1=ProductName1 B2=Productdescription1
> A2=ProductName2 B2=Productdescription2
>
> Etc..
>
> To:
>
> productname1.txt (co
How can I create multiple new files using data from excel? For
example:
A1=ProductName1 B2=Productdescription1
A2=ProductName2 B2=Productdescription2
Etc..
To:
productname1.txt (containing productdescription1)
productname2.txt (containing productdescription2)
in specified folder "products" f
hi daniel
i tried your code its working perfectly thanks
but wht in this situation in attached sheet i want to remove all non wanted
charters at the end of email ids...
Thanks
Ashish
--~--~-~--~~~---~--~~
Thanks Ashish, but don't forget u will be sending more like this. correct?
:)
On Sun, Sep 6, 2009 at 4:15 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Harmeet,
>
> That's fantastic. and good that you protected the code. I want
> everyone to try, so that their logic and vba skills can be
More precisely :
Sub test()
Dim c As Range
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, " ", "")
End If
Next c
Hi.
Select range and execute the following macro :
Sub test()
Dim c As Range
For Each c In Selection
If c.Value <> "" Then
c.Value = Application.Clean(c.Value)
c.Value = Application.Trim(c.Value)
End If
Next c
End Sub
Best regards.
Hi Ashish,
Try OpenXL - http://www.openexcel.com
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
+91..40.48.4
hi i need a code or macro who will clean unwanted spaces and character in
the colums conatings email ids
like
ashish k...@gmail.com. result should be ashishk...@gmail.com
koulashish @gmail.com...result should be koulash...@gmail.com
koul.ashish @gmail.com result should be koul.as
hi all
hi can anyone give me code or macro to clean as well as trim my data in a
sheet
thanks
ashish
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tu
Dear All Excel Gurus,
I need help to recover my password / crack password for attached file.
Regards,
Nipun
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and
Have a look at the attached file.
Best regards.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Aligahk06
Sent: samedi 5 septembre 2009 14:39
To: excel-macros@googlegroups.com; aamir...@gmail.com; dilipan...@gmail.com;
findsarfa...@gmail.co
Dear Members,
Finally With all your support and good wishes we have completed 6000
Members in our Google group.We have achieved this mark in very short
span of time.I hope this group reaches more milestones and help more &
more people around the world.
Our Google group is a free service. Please
Eric,
If your Begin Date is in cell A2 and cell B2 has the Number of years.
To calculate the Renewal Date try the following formula in cell C2:
=A2+(B2*365.25)
Begin DateYearsRenewal Date
-
10/25/2005410/25/2009
Norman
Hi Harmeet,
That's fantastic. and good that you protected the code. I want
everyone to try, so that their logic and vba skills can be sharpened.
Well Done Harry.
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
On Sep 5, 5:07 pm, Mahesh wrote:
> Dear Firends,
>
> need ur help here.
>
> i want to enter number in sheet 2 and want to match it in
sheet 1
> if the same number is not in the sheet 1 then it will find
the nearest
> number either +1 or -1.
>
> Please check the attached sheet.
>
> --
> With Lo
Try (begin date in A1) :
=DATE(YEAR(A1)+CEILING(DATEDIF(A1,TODAY(),"y")/2,1)*2,MONTH(A1),DAY(A1))
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of Eric
> Sent: samedi 5 septembre 2009 21:05
> To: MS EXCEL A
On Sep 6, 5:04 am, Eric wrote:
> I'm having a difficult time with something that sounds
pretty simple
> on the surface but seems to get devilishly hard (at least
for me) as I
> look further into it. I need to calculate contract renewal
dates based
> on the original signing date. For a 1 year term
Hi Eric
I have created a solver and same is attached with this email. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/6/09, Eric wrote:
>
>
>
>
> I'm having a difficult time with something that
23 matches
Mail list logo
