$$Excel-Macros$$ Re: Number ranges in a cell

2008-10-30 Thread Amanda
Thank you!! This worked perfectly. Now I just have to try to understand how it worked! On Oct 29, 4:01 pm, Akhilesh Karna [EMAIL PROTECTED] wrote: You can run the following macro assuming that your texts are in column-A. If it differs, change the program accordingly. Hope it helps. Option

$$Excel-Macros$$ Re: Lookup for repetitive items

2008-10-30 Thread Nidhesh Dhawan
Thanks Kamran, This is working fine, I think this is the best possible alternative.   On Tue, 28 Oct 2008 Kamran Haider wrote : Dear nidheshd , Please have solution file .Please give your feedback on the solution . Allah Hafiz ,Kamran Haider . Date: Thu, 23 Oct 2008 11:56:13 +From:

$$Excel-Macros$$ Help..........!

2008-10-30 Thread Santhosh Kumar M K
Dear friends, I was Protected one excel workbook.But I forgot a password.Any other ways possible to unprotected ? Rgds, Santosh --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group,

$$Excel-Macros$$ How to hid formula in a cell or sheet

2008-10-30 Thread vinu
Hi All, Could you pls let me know how to hide and unhide only formula in a particular cell or a sheet. Regards, vinu. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to

$$Excel-Macros$$ Concatenate

2008-10-30 Thread vinu
How to concatenate the below one. A1=India B1=Bangalore C1=12:10Am Thanks in advance. Vinu. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to

$$Excel-Macros$$ Re: Number ranges in a cell

2008-10-30 Thread Amanda
I have a spreadsheet I would like to upload with the column in question - how do I upload it? On Oct 29, 7:19 pm, Dave Bonallack [EMAIL PROTECTED] wrote: Hi, We need to know how the current data appears in the cells. for example, 10 - 12 Is that 10 in column A, - in Column B, and 12 in

$$Excel-Macros$$ how to activate double click

2008-10-30 Thread vinu
Hello All, I have problem with double click activation in excel. I have data in A and C column. But if I enter 1 and 2 in B column, select both and double click its not taking automatically, I need to drag manually. could you pls let me how to solve this. Regards, vinu.

$$Excel-Macros$$ Re: Concatenate Formula

2008-10-30 Thread vinu
Hi this works well. How to concotenat the time formate for eg: MS Exce 12:15 AM how to do this.. Regrds, vinu. On Oct 29, 9:18 am, Bhavish Poddar [EMAIL PROTECTED] wrote: Hi use this function : =A1 B1 TEXT(C1,dd-mmm-yy) where A1 = MS B1 = Excel C1 = 29-0ct-08 On Fri, Oct 24, 2008 at

$$Excel-Macros$$ Using Excel's OnTime function to capture data on a daily basis

2008-10-30 Thread prav78uk
Hi I was wondering if you could help me. I basically need to instruct excel to automatically plot the cell value of a given cell, each day at set time. So the two values would be the cell value and the date. The cell value on same days may be the same as the previous day. I thought using

$$Excel-Macros$$ Re: how to activate double click

2008-10-30 Thread Ajay Varshney
you need to double click on the plus sign which comes below the second number (2). On Thu, Oct 30, 2008 at 11:40 AM, vinu [EMAIL PROTECTED] wrote: Hello All, I have problem with double click activation in excel. I have data in A and C column. But if I enter 1 and 2 in B column, select

$$Excel-Macros$$ Re: Help..........!

2008-10-30 Thread Ajay Varshney
download the software for cracking password. Install that software and you can get to know your old password. search on google for the software On Thu, Oct 30, 2008 at 4:09 PM, Santhosh Kumar M K [EMAIL PROTECTED]wrote: Dear friends, I was Protected one excel workbook.But I forgot a

$$Excel-Macros$$ Re: Concatenate

2008-10-30 Thread Ajay Varshney
=A1 B1 TEXT(C1,HH:MM AM/PM) Use the above forlula On Thu, Oct 30, 2008 at 11:19 AM, vinu [EMAIL PROTECTED] wrote: How to concatenate the below one. A1=India B1=Bangalore C1=12:10Am Thanks in advance. Vinu. --~--~-~--~~~---~--~~ Visit the blog to

$$Excel-Macros$$ Re: how to activate double click

2008-10-30 Thread Sumeet Jain
Try going to Tools - Options - Edit. On left hand side under Settings, you would see the option Edit directly in cell. Enable it by putting a tick mark and say ok. Now, you should be able to double click directly into the cell. Let me know if I have missed any part of your questions. Rgds Sumeet

$$Excel-Macros$$ Re: Concatenate Formula

2008-10-30 Thread Ajay Varshney
=A2 B2 TEXT(C2,HH:MM AM/PM) Use the above formula On Thu, Oct 30, 2008 at 11:15 AM, vinu [EMAIL PROTECTED] wrote: Hi this works well. How to concotenat the time formate for eg: MS Exce 12:15 AM how to do this.. Regrds, vinu. On Oct 29, 9:18 am, Bhavish Poddar [EMAIL PROTECTED]