You're very welcome.
On Feb 23, 3:36 pm, Art rombona...@gmail.com wrote:
Chris,
Thanks a lot. I would've spent weeks (not to say months) to figure
this out.
Tks again,
Art.
On Feb 21, 12:11 pm, Chris Spicer chris.spi...@technicana.com wrote:
Hi Art,
Contract codes are always a
i think even the formula below will solve your problem.
=TODAY()-WEEKDAY(TODAY(),3)
Regards,
Sarfaraz
Do visit me on MS Excel help http://findsarfaraz.blogspot.com/
On Mon, Feb 23, 2009 at 4:25 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Savio,
Supposing you have the date in cell A1,
Dear All
I have excel file with 10,000 email id in one column. I want to send mail to
all of these. i have to put , or ; at every email id so that it could be
send to all. How can i do it
pl tell help me -.
regards
--
Amit Arora
--~--~-~--~~~---~--~~
Dear Amit,
The easiest way of sending an email for 1 IDs is doing mail merge using
MS Word.
On Tue, Feb 24, 2009 at 6:23 PM, amit arora amit.aur...@gmail.com wrote:
Dear All
I have excel file with 10,000 email id in one column. I want to send mail
to all of these. i have to put , or ;
---
---
Hi,
However, Gmail, Yahoo and Hotmail automatically does this task. So
Solution
Great solution
On Tue, Feb 24, 2009 at 6:34 PM, Naga iamsa...@gmail.com wrote:
Dear Amit,
The easiest way of sending an email for 1 IDs is doing mail merge using
MS Word.
On Tue, Feb 24, 2009 at 6:23 PM, amit arora amit.aur...@gmail.com wrote:
Dear All
I have excel file with 10,000
suppose you have email id in A column starting from A2
in B2 type =B2
and in B3 type = B2 , A3
Then drag it till the cell where you have email addresses.
in the last cell you will get
emailid1, emailid2 and so on.
copy text in last cell and paste in notepad or use copy paste value
Hai puneet
It is possible with bseindia website with vlookup method.
send me your sample data i will create the link with bseindia and send back
to you.
Regards
Saravanan A R
On Thu, Feb 19, 2009 at 10:59 AM, Puneet Jain puneet...@gmail.com wrote:
Dear all
Not recieved any reply for the
Hi Naga,
Here is the short cut.
pls. see the file attached.
regds.,
Johnson
On Tue, Feb 24, 2009 at 6:34 PM, Naga iamsa...@gmail.com wrote:
Dear Amit,
The easiest way of sending an email for 1 IDs is doing mail merge using
MS Word.
On Tue, Feb 24, 2009 at 6:23 PM, amit arora
Hai,
Try this
=NOW()-WEEKDAY(NOW(),1)+2
it will help you i think,
Regards
Saravanan A R
On Sat, Feb 21, 2009 at 8:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi,
Below is the formula-
The solution suggested by Mr. Johnson is the easiest for a layman. I fail
to understand why people make simple things complicated.
N.Shivkumar
Office : +914027685423
Mobile : +919866533180
Res : +914040035774
Alternate Email : shiv1...@yahoo.com
Assuming that your data does not have any empty rows:
Sub DeleteWhereExtra()
Dim I As Integer
For I = 2 To Worksheets(Sheet1).Range(A65535).End(xlUp).Row
If Worksheets(Sheet1).Range(A I).Value = extra Then
Worksheets(Sheet1).Range(D I).ClearContents
End If
12 matches
Mail list logo