Hi Ashish,
Select the cell, press Shift + "Space", press Ctrl + "+". If you want the
current cell to move down and the new row to be inserted before that, then
select that cell before following the above steps. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilip
i am aready ahving data in col a and col b ,,etc
but i want to insert new row when cell value in cal b is parent co.
On Wed, Sep 23, 2009 at 8:37 PM, Sandeep Kumar Maurya wrote:
> Hello Ashish,
>
> Do you have your data ready or you want to enter the data then a new row
> below it.
> Means y
Hello Ashish,
Do you have your data ready or you want to enter the data then a new row
below it.
Means your data already have "parent co" in column B are you going to enter
it in column B.
Regards
Sandeep
On Wed, Sep 23, 2009 at 10:29 AM, ashish koul wrote:
> inserting a blank row with matchi
Hi Ashish,
Your query has been solved and attached herewith. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/11/09, ashish koul wrote:
>
> hi
>
> i wanted a formula in sheet 2 which will tell me
You are always welcome...!!
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/13/09, Prashant Bhawar wrote:
>
> Thanks Dilip its really useful to me
>
> On Sun, Sep 13, 2009 at 11:57 AM, prashant bhawar > w
Thanks Dilip its really useful to me
On Sun, Sep 13, 2009 at 11:57 AM, prashant bhawar
wrote:
> Thanks Dilip its really useful to me
>
>
>
> On Sun, Sep 13, 2009 at 10:07 AM, poojari sreevijay
> wrote:
>
>> Hi Prashant,
>>
>> Please find the attached Excel sheet. Hope this would solve your query
Hi Prashant,
Please find the attached Excel sheet. Hope this would solve your query.
Thanks,
Sreevijay
2009/9/12 Prashant Bhawar
>
> Hello Frnds I want some solution
>
> I want to separate First Name, Middle Name & Last Name
>
> means if I hav Full name in A1 then i want First name in B1,
Hi Prashant,
Refer to the attached file. I have given two set of nested formulas to
achieve the required results. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/12/09, Prashant Bhawar wrote:
>
>
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 went through the site i am able to clean and trim but in below ca
; *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 went through
: $$Excel-Macros$$ Re: help plz
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
Hi Ashish,
Use following formula to remove whitespace.
=SUBSTITUTE(B2, " ", "")
Regards,
Swapnil.
On Sun, Sep 6, 2009 at 9:29 PM, ashish koul 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
>
> ashish k...@gmail
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 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
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 Ashish,
Attached workbook has the solution to your query. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/29/09, ashish koul wrote:
>
> hi i want to apply vlookup formula to gind the age of pe
Maybe koul doesn't need this solution, for example, if there are more
people in the sheets, how to do it?
On Aug 30, 3:34 am, Ramkrishna Padhi
wrote:
> Hi Ashish,
>
> Please find the attached solution.
>
> Thanks & Regards,
> Ramkrishna T. Padhi
>
> On 8/29/09, ashish koul wrote:
>
>
>
>
>
> >
Hi Ashish find the attached solution
Regards
Sandeep
- Original Message -
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Saturday, August 29, 2009 8:38 PM
Subject: $$Excel-Macros$$ help plz
hi i want to apply vlookup formula to gind the age of person in the atta
Hi Ashish,
Please find the attached solution.
Thanks & Regards,
Ramkrishna T. Padhi
On 8/29/09, ashish koul wrote:
>
> hi i want to apply vlookup formula to gind the age of person in the
> attached sheet in sheet 1
>
> for example i want to find the age of rajesh and i don't know whther it is
19 matches
Mail list logo
