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,
If I understand, you might solve it by doing:
Your Data New Column
Column A Column B
-0.01 =IF(A2=0,0,B1+1)
0 =IF(A3=0,0,B2+1)
-0.002 =IF(A4=0,0,B3+1)
-0.005 =IF(A5=0,0,B4+1)
-0.01 =IF(A6=0,0,B5+1)
-0.004 =IF(A7=0,0,B6+1)
0 =IF(A8=0,0,B7+1)
-0.003 =IF(A9=0,
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
thank for the reply. But I do not want to use excel to send email. May
I know if there is a work around to automatically fill subject line,
TO and CC field whenever I click on reply or forward?
Regards
On Aug 2, 7:10 pm, mahesh parab wrote:
> Hi Sahil
>
> below mention link will help you.
>
> h
yes, please email me at fahe...@gmail.com thanks
On Aug 7, 1:06 am, fongie wrote:
> Hi Osiso
>
> You sent me an email today with another query.
>
> I tried to send back to paraport email but got mail server rejections.
>
> Is there another email I can email you on?
>
> Alvin
>
> On Aug 6, 3:05 a
Thanks Dilip, but this is not what I want.
This is the Attached file I want to solve the rank as per the criteria in a
single cell without using any additional cell as I used Column K values.
Is there is any way to combine and use array values as range in any formula?
This is just a deep step i
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&CHAR(13)&A2&CHAR(13)&A3
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@googlegroups.com
Hi Ruc
Most one knows..(Joke.)
Simply go to Insert->Name->Define.
Select the given name and click "delete" ( if you are using excel 2003)
OR
Go to Formulas->Name Manager.
Select the given name and click "delete" (if you are using excel 2007)
Regards,
Upendra Singh
+91-9910227325, +91-9
Hi All,
I have selected A1 to A5 and given some name(In Named Range).
Now I want to remove it. Anyone know how to do it???
Regards,
Suresh
--~--~-~--~~~---~--~~
--
Some important link
Hi Sandeep,
I have given two ways in the following worksheet.
Note:- If you have any test scenario, pls share.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 10, 2009 at 10:37 AM, Sandeep wrote:
Hi Giorgio,
Solved workbook is attached. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 10, 2009 at 3:09 PM, Giorgio wrote:
>
> Hi all,
> I have a series of % values that can be either 0
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
Can someone help?
I have a user form that i created in a spreadsheet to automatically
launch when the workbook is opened. Can anyone tell me what code i can
use to prevent the workbook from being displayed when i open it and
only display the user form? Also where i need to place this.
Also what
Hi,
If you will have a "." and space separating the supplier name, you can
try: =RIGHT(A1,(LEN(A1)-FIND(CHAR(46),A1,1)-1)) where A1 is the cell
with the supplier name.
Hope it helps!
CC
On Aug 11, 3:43 am, Suhas wrote:
> Hi,
>
> We have a file which is downloaded from HTML page.
>
> The data
Vivek,
Sorry to bother.
Can we create drafts with attachement of New workbook generate by below macro
as per client.
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
-Original Message-
Fro
hello friends
i dont know much about vba
i had bring calender to my sheet, but don't know how to proceed
further,can anybody guide me
i had written the code
my query is how to insert the date by using calendar, i can see only
embedded calendar on my sheet
Have A Nice Time & Enjoy Life
Regards:
C
Dear All,
Greetings of the day,
I want to develop a user form with following condition.
a) PO#.
b) Po validity. e.g from (31/7/2009 to 25/4/2010)
c) Po Amount.
d) PO Description. e.g (this po is generated for work so on.)
e) Search PO (eg by Po Number )
F) po STATUS ( e.g Closed or open on
Hi,
We have a file which is downloaded from HTML page.
The data looks like below
A. Raman Industries
I. Rajesh Industries
III. Manoj Polymers
Rakesh Printers
Now i want to extract only the names of the suppliers, I dont want A.,
I. etc, Because i maintian another file which has correct suppl
Dear Deepak,
Thanks a ton !!
Iqbal
On 8/11/09, Deepak Rai wrote:
>
> Hi,
>
> In the Developer Tools click on More Controls & then select Calender
> Control 12.0.
> Please follow the below steps to get the Calender Control:
>
> 1. Right Click on Menu Bar
> 2. Select "Customize Quick Access
20 matches
Mail list logo
