Hi Vijender,
Its not working.. I have attached the XL file below pls look into the same.
The right/left function wont work as date is not in a text formate.
Regards,
Vinu.
2008/11/5 vijender kumar [EMAIL PROTECTED]
Hi..
This is very easy. Just use the left function/right function to get
Chk attached file
Regards
Harish Upadhyay
On 11/4/08, ram bhagath [EMAIL PROTECTED] wrote:
Hi all,,
I have attached the file, and explained the proble there only. I wanted to
pick amount from another table by formula. I tried with vlookup i didnt get
answer. Pls help me.
Regards,
Hi Ram,
Solution is attached herewith in EXCEL.
Use of Pivot table may give you this solution.
Regards,
Hitesh Dhare
+919824004308
New * Email ID: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
From: excel-macros@googlegroups.com
[mailto:[EMAIL
right click on cell and go to Format - Protection tab.. if locked box is
checked, cell will locked after protecting the sheet. If hidden box is checked,
cell formula will be hidden (i.e. will not show in formula bar) after
protecting the sheet. To lock a range, select your range and then go to
Use below functions:
For date:
=TEXT(A1,mm/dd/)
For time:
=TEXT(A1,hh:mm:ss AM/PM)
A1 is the cell where the data (date and time) is stored.
_
There are known knowns. These are things we know
Dear Ram
Use Pivot Table, it is simpler then vlookup
Regards
On Tue, Nov 4, 2008 at 11:57 PM, ram bhagath [EMAIL PROTECTED] wrote:
Hi all,,
I have attached the file, and explained the proble there only. I wanted to
pick amount from another table by formula. I tried with vlookup i didnt
A2 =TEXT(A1,MM/DD/YY) -- u will find date 11/4/2008
A3 =TEXT(A1,HH:MM:SS AM/PM)-- u will find Time 5:51:00 PM
Regards
Harish Upadhyay
On 11/4/08, vinu [EMAIL PROTECTED] wrote:
Hi All,
I have a data like this in a single cell for eg A1 11/4/2008
5:51:00 PM.
I need date in A2
Ladies Gents:
I’m an experienced excel user (10+ years) and have encountered a
problem that I cannot figure out. I’m creating a tool where there is
a free text area where the users will input a list of locations (up to
60 values that can repeat and are in no particular order - some cells
can
How do I create a macro in Excel that will count the number of like
values in a cell?
For Example:
how many people live in each city in an excel spreadsheet of names
and addresses
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at