Hi All,
There is requirement of a candidate in naukri.com which is master in
1. Excel, advanced Excel, VBA
2. problem solving skill
3. Mental Aptitude
4. Communication Skill
Salary Range : 14 K
if u found all aptitude in yourself mail your resume
divaker.pan...@naukri.com
Divaker
--
---
Hi,
Can u send Excel Sheet of this example.
thanx
On 7 March 2011 12:17, Krish wrote:
> Hi ,
>
> I have data in row and column 1-3, and needs to club the data in
> single row and column since the data acorss three columns,
>
> Pls help me.
>
> Regards,
> Krish Kandy.
>
> --
>
> ---
Dave,
Hey! I'm an ENGINEER, not an ENGLISH major!
Or a veterinarian for that matter!
What kind of dog would jump over a fox anyway...
Always seemed (seems?) suspicious (spurious?), if you ask me...
lol.
Paul
From: Dave Bonallack
To: "excel-macros@googlegroups.
BTW, I realize the pangram is "actually":
"The quick brown fox jumps over the lazy dog"
I simply allowed my twisted sense of humor to distort the true purpose of the
phrase...
Paul
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, March 7
another alternative actually reduces the wear on the ol' keyboard.
=A2&" "&B2&" "&C2
accomplishes the same thing!
Paul
From: "davidpk...@verizon.net"
To: excel-macros@googlegroups.com; kandy.kr...@gmail.com
Sent: Mon, March 7, 2011 1:32:54 PM
Subject: Re: $$
use concatenate function or & operator like
=A1 & B1 & C1
etc
On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar wrote:
> Hi,
>
> Can u send Excel Sheet of this example.
>
> thanx
>
>
> On 7 March 2011 12:17, Krish wrote:
>
>> Hi ,
>>
>> I have data in row and column 1-3, and needs to club the
you can do it from registry
On Mon, Mar 7, 2011 at 4:06 PM, dpk wrote:
> how to increse rows in excel 2007 from 65 k to more
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips
very nice speech Mr. Paul Sir.
Regards
Sumit Vyas
On Tue, Mar 8, 2011 at 7:07 PM, Paul Schreiner wrote:
> Dave,
> Hey! I'm an ENGINEER, not an ENGLISH major!
> Or a veterinarian for that matter!
> What kind of dog would jump over a fox anyway...
> Always seemed (seems?) suspicious (spurious?)
=A2&" "&B2&" "&C2 = FSD COM com
On Tue, Mar 8, 2011 at 7:17 PM, Paul Schreiner wrote:
> another alternative actually reduces the wear on the ol' keyboard.
>
> =A2&" "&B2&" "&C2
>
> accomplishes the same thing!
>
> Paul
>
> --
> *From:* "davidpk...@verizon.net"
> *To:
Hi Paul
You give me excellent answer thank you very much, but when I give the
formula timevalue(substitute(d2,".","")) it shows error value #value!.
pls check it.
Regards
Rajesh kainikkar
On 3/7/11, Paul Schreiner wrote:
> Excel has it's own internal date/time functionality.
> A "date" is the
Your substitute command is REMOVING the "." completely.
You should be REPLACING the "." with a colon (":")
Next... is there always a "."?
If not, then we're going to have to look at alternatives.
Paul
From: Rajesh K R
To: excel-macros@googlegroups.com
Sent:
Dear All,
I need to do profit and loss analysis through excel presentation for
different project for month, problem is our client billing cycles are
different to different to all the projects, example: AOC (project) billing
cycle every month 15th to next month 14th for NCR every month 24th to next
Hi Paul,
Well said. I tried to let it go unchallenged, but since I had nothing better to
do at the time... :)
Dave.
Date: Tue, 8 Mar 2011 19:12:46 +0530
Subject: Re: $$Excel-Macros$$ OT
From: svyas0...@gmail.com
To: excel-macros@googlegroups.com
very nice speech Mr. Paul Sir.
Regards
Sumi
Dear Ashish,
Thanks alot for the help.
One thing more to add. Lets say
Main Folder: Jan 2011>>> Sub Folder: 10 sub folder >>> 20 files each
sub folder
Can I rename all 200 files in one go.
On Mar 7, 8:13 am, "OpenExcel.com" wrote:
> *Replace* Characters in the Filenames of a
> Directory
Dear all,
I have one attach file where I am keeping the serial pipe number but the
problem is I am getting the same pipe number many times and it's hard to
search whether provide pipe number are reported or not.
Can u have any formula/validation i.e. when I type the reported pipe number
its
*Thanks Milindthanks a lot.*
On Mon, Mar 7, 2011 at 10:05 AM, mkarnik wrote:
> Quick reply for 2nd point:
> IN VBE,
> Select:
> Tools / VBA Project Propoerties / Protection
> Now enable "Lock Project for Viewing", enter password twice and click
> on OK.
> Most Imp: Do not forget the passowr
see if it helps
On Tue, Mar 8, 2011 at 8:51 PM, Rabindra Thapa wrote:
> Dear all,
>
>
>
> I have one attach file where I am keeping the serial pipe number but the
> problem is I am getting the same pipe number many times and it’s hard to
> search whether provide pipe number are reported or not
17 matches
Mail list logo