$$Excel-Macros$$ Re: Hii..

It is really nice, but for undesrstanding can you please guide that what is the use of ? Where we need to put this? Regards, Darshil Shah. On Tue, Aug 11, 2009 at 4:42 PM, soura...@gmail.comsoura...@gmail.com wrote: Hi Ruchi Here is formula for your reference =A1 A2 A3 On Aug 11,

$$Excel-Macros$$ Re: Hii..

Dear Shah, Use of explained below -: 1.) To seperate a references / texts in the formula result 2.) To include some text in - between the references results. Note:- Between formulas / References you can use to include any text or space. e.g. reference 1 dilip reference 2 Let me know

$$Excel-Macros$$ Re: Hii..

Hi Ruchi, Type this in B1 =A1 A2 A3 Thanks Prashanth On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi Friends, I have data in three cell A1= My Name A2= is A3= Ruchi can i have a formula wherein the below info in cell A1,A2 A3 appears in *single cell *

$$Excel-Macros$$ Re: Hii..

. Regards - Dave. -- Date: Tue, 11 Aug 2009 19:33:25 +0530 Subject: $$Excel-Macros$$ Re: Hii.. From: dilipan...@gmail.com To: excel-macros@googlegroups.com Hi Ruchi, Attached workbook has two solutions for this problem. Thanks -- DILIP KUMAR PANDEY MBA-HR,B

$$Excel-Macros$$ Re: Hii..

@googlegroups.com Subject: $$Excel-Macros$$ Re: Hii.. Date: Wed, 12 Aug 2009 09:42:40 +0800 Hi Ruchi, I think you need the following formula: =A1CHAR(13)A2CHAR(13)A3 The cell format needs the Text Wrap option selected. Regards - Dave. -- Date: Tue, 11 Aug 2009

$$Excel-Macros$$ Re: Hii..

Hi Ruchi, Attached workbook has two solutions for this problem. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi Friends,

$$Excel-Macros$$ Re: Hii..

Hi, Check the attached sheet to find how to use concatenate. For vertical look select wrap text in alignment tab in format cells. Anurag On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi Friends, I have data in three cell A1= My Name A2= is A3= Ruchi can i

$$Excel-Macros$$ Re: Hii..

Hi Ruchi Here is formula for your reference =A1 A2 A3 On Aug 11, 4:27 pm, Ruchi Saxena ruchi.saxe...@gmail.com wrote: Hi Friends, I have data in three cell A1= My Name A2= is A3= Ruchi can i have a formula wherein the below info in cell A1,A2 A3 appears in *single cell * i.e.

$$Excel-Macros$$ Re: Hii

To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Hii i think upender singh formula is not working properly , i changed time to 2:20 its is showing reference of time 2:30 , is it right? On Jul 22, 3:23 pm, Dhananjay Pinjan dppin...@gmail.com wrote: Hi Friends, Hi Ruchi, Hope following

$$Excel-Macros$$ Re: Hii

To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Hii i think upender singh formula is not working properly , i changed time to 2:20 its is showing reference of time 2:30 , is it right? On Jul 22, 3:23 pm, Dhananjay Pinjan dppin...@gmail.com wrote: Hi Friends, Hi Ruchi, Hope

$$Excel-Macros$$ Re: Hii

Hi Ruchi, Attached is the solution. I am presuming that the data in the yellow cell is extracted with the time inputted in the adjacent cell. Please let me know if you have any questions. Thanks Regards Ankit Mehra On 7/20/09, Ruchi Saxena ruchi.saxe...@gmail.com wrote: Hi friends, i m

$$Excel-Macros$$ Re: Hii

Hey Ruchi i have attached soluction, see this one u requrired or something eals . Regards: ╚►♥ѕαη∂єєρ♥◄╝ On Mon, Jul 20, 2009 at 11:44 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi friends, i m new to this group... Can somebody help me with the attached sheet Regards, Ruchi

$$Excel-Macros$$ Re: Hii

Hi Thanks a lot to Ankit, Shreyans, Mahesh but any other time entered say 5:16 does not give me answer (the attached sheet says that till 5:15 it is L but from 5:16 to 5:30 it is O so on) so when i enter 5:16, it must give status as O Can you please refine such that any time entered will give

$$Excel-Macros$$ Re: Hii

Well Ruchi, For that, edit the Vlookup function entered... just replace the last argument passed from 0 to 1) hope it helps Thanks Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 21, 2009 at 3:42 PM, Ruchi Saxena

$$Excel-Macros$$ Re: Hii

: Tuesday, July 21, 2009 3:42 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Hii Hi Thanks a lot to Ankit, Shreyans, Mahesh but any other time entered say 5:16 does not give me answer (the attached sheet says that till 5:15 it is L but from 5:16 to 5:30 it is O so

$$Excel-Macros$$ Re: Hii

9435086605 (Mobile) akagarw...@gmail.com *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Ruchi Saxena *Sent:* Tuesday, July 21, 2009 3:42 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Hii Hi Thanks a lot to Ankit

$$Excel-Macros$$ Re: Hii

Hi.. I cant able to understand the question.. also I ve not received any attachment.. Pls mention the question clearly... -- Best Regards Anish --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Hii

Hi Ruchi, attached is the solution. On Mon, Jul 20, 2009 at 11:44 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi friends, i m new to this group... Can somebody help me with the attached sheet Regards, Ruchi -- With Love, Mahesh Bisht