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. <<>>>
Let me know if you still fac
; =A1&CHAR(13)&A2&CHAR(13)&A3
> The cell format needs the Text Wrap option selected.
> Regards - Dave.
>
> ____
> Date: Tue, 11 Aug 2009 19:33:25 +0530
> Subject: $$Excel-Macros$$ Re: Hii..
> From: dilipan...@gmail.com
> To: exce
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.com wrote:
>
> Hi Ruchi
>
> Here is formula for your reference
>
> =A1&" "&A2&" "&A3
>
>
>
> On Aug 11
Hi Ruchi,
Type this in B1
=A1&" "&A2&" "&A3
Thanks
Prashanth
On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena 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.
...@hotmail.com
> To: excel-macros@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:
> =A1&CHAR(13)&A2&CHAR(13)&A3
> The cell format needs the Text Wrap option selected.
; The cell format needs the Text Wrap option selected.
> 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,
&g
Hi Ruchi
Here is formula for your reference
=A1&" "&A2&" "&A3
On Aug 11, 4:27 pm, Ruchi Saxena 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. it
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 wrote:
> Hi Friends,
>
> I have data in three cell
>
> A1= My Name
> A2= is
> A3= Ruchi
>
> can i have a formu
Hi Ruchi,
Sorry, correction:
=A1&CHAR(10)&A2&CHAR(10)&A3
Regards - Dave.
From: davebonall...@hotmail.com
To: excel-macros@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:
=A1&
Hi Ruchi,
I think you need the following formula:
=A1&CHAR(13)&A2&CHAR(13)&A3
The cell format needs the Text Wrap option selected.
Regards - Dave.
Date: Tue, 11 Aug 2009 19:33:25 +0530
Subject: $$Excel-Macros$$ Re: Hii..
From: dilipan...@gmail.com
To: excel-macros@googl
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 wrote:
> Hi Friends,
>
> I have data in thr
alf Of ankurcma
> Sent: Wednesday, July 22, 2009 4:55 PM
> 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
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 wrote:
> Hi Friends,
>
> Hi Ruchi,
> Hope follo
his formula has worked
>
> > Regards,
>
> > Ruchi
>
> > -- Forwarded message ----------
> > From: Upendra Singh
> > Date: Wed, Jul 22, 2009 at 7:46 AM
> > Subject: $$Excel-Macros$$ Re: Hii
> > To: excel-macros@googlegroups.com
>
gt; Thanks Upendra,
>
> This formula has worked
>
> Regards,
>
> Ruchi
>
>
> -- Forwarded message --
> From: Upendra Singh
> Date: Wed, Jul 22, 2009 at 7:46 AM
> Subject: $$Excel-Macros$$ Re: Hii
> To: excel-macros@googlegroups.com
>
>
> Hi
Hi.. I cant able to understand the question.. also I ve not received any
attachment.. Pls mention the question clearly...
--
Best Regards
Anish
--~--~-~--~~~---~--~~
--
Some import
Assam
>
> +91 361 2638864 (Telefax)
>
> +91 361 2517820 (Office)
>
> +91 361 2606184 (Residence)
>
> +91 9435086605 (Mobile)
>
> akagarw...@gmail.com
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Ruchi Saxe
: 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:3
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 on)
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 wrote:
>
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 wil
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 wrote:
> Hi friends,
>
> i m new to this group...
>
> Can somebody help me with the attached sheet
>
> Regards,
>
> Ruchi
>
> >
>
--
--~--
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 wrote:
>
> Hi friends,
>
> i m new to this group..
Hi Ruchi,
attached is the solution.
On Mon, Jul 20, 2009 at 11:44 PM, Ruchi Saxena wrote:
> Hi friends,
>
> i m new to this group...
>
> Can somebody help me with the attached sheet
>
> Regards,
>
> Ruchi
>
> >
>
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~---
24 matches
Mail list logo
