Formula
Wed, 19 Nov 2008 09:13:27 GMT
Dear All
I have a cell which contains quite a long reference number. The Number is
divided up into 5 sections, a " / " being the separator.
How do I extract what is between the 2nd "/" and the 3rd "/" ?
Heres hoping you can help.
Cheers
Darren
--
Message posted via OfficeKB.com
http://www.off ...
|
Using Excel and SQL
Wed, 19 Nov 2008 00:53:01 -0800
Hello,
I have a list of postcodes in Excel and I want to match them using an SQL
table from a warehouse server
I have been told that I can use VBA programming but what code do I use or
can I be pointed in the right direction?
cheers
...
|
Multiple if formula
Tue, 18 Nov 2008 23:48:13 -0800
Hi, I require a formula that expenses a prepayment up to an anniversary date
from the date it was paid on a monthly basis.
i.e. The due date is Feb 09 and the payment was made in Apr 08 of $800 so I
have a monthly expense of $80 which I want to start in Apr 08 and end in Jan
09 (I have columns for each mont ...
|
Opening Excel 2007 using Excel 2003
Tue, 18 Nov 2008 22:15:01 -0800
Issue 1:
If I take a Excel 2007 file saved with a "xlsx" file extension and I
manually change the filename extension to "xls", then I open the Excel file
using Excel 2003, it displays the following popup message to the user:
"This file is not in a recognizable format.
- If you know the file is from anoth ...
|
Find the next date for a product
Tue, 18 Nov 2008 21:24:01 -0800
Hello,
I have an excel document with two sheets, sheet1 contains a list of product
codes in column A and a date next to each in column B. Sheet2 is almost the
same but with different dates and some products aren't on the list.
For each product code - In column C on sheet one I want to find the same
produ ...
|
Automatically hide a row if it is empty
Tue, 18 Nov 2008 21:09:02 -0800
Hi,
I would like Excel to hide a couple of rows if a formula input in the cells
of that row results in "" and show them if the formula shows numbers. Has
anyone worked out how to do it?
Thanks
Steve
...
|
right click save as feature
Tue, 18 Nov 2008 21:08:01 -0800
hi,
need help. why when i right click a xls file, there is no 'save as' feature?
...
|
|
|
I cannot CANCEL 'Speak Cells on Enter'
Tue, 18 Nov 2008 20:01:01 -0800
We have tried everything, but no matter what, 'Speak Cells on Enter'
continues. I have added "Stop Speaking Cells" and tried using that. I have
tried adding the 'Speak Cells on Enter' tool to the Quick Access and tried
toggling it. Nothing. Having turned it on... Nice thought... I CANNOT
turn it off..
...
|
How to query a spreadsheet?
Tue, 18 Nov 2008 18:46:00 -0800
Hi all,
I'm trying something completely new for me and have no idea whether i'm on
the right track or not. I'm trying to create a relational database in Excel.
I have a workbook containing 4 worksheets. Each worksheet has a table as
follows:
Sheet 1: contains a table of 'Suppliers Details' (ID, Name, Locatio ...
|
TIME
Tue, 18 Nov 2008 18:28:01 -0800
Hi
Is it possible to place a check on a cell that user can only enter time 1-12
hrs time format and noy 1-24 hrs format.
Example, he should be able to input from 1-12 , but not from 13 to 24 ...
|
