I have a .csv file produced by our accounting software Exchequer containing
my data which contains the following:
Department
Invoice Value

I need to figure out how to convert 200:1 in cell A1 to 200 for cell B1,
which would then be divided by 1
A1                 B1
200:1            I need to exclude the :1 from 200:1 and then divide 1 by 200

I have a fixed range. e.g.  $55,000=85% and $80,000=115%.  If I put $63,000
in a cell how would I create a formula to tell me what percentage it is in
this range

Hi Experts:
I've poured over the other questions and responses on this site and either
missed my situation or it's not there...I need help with what should be so
simple...

I copied data from a ".csv" file to an excel and used the "SUMIF"
functionality. It didn't work. When I use the same formula to but manually
enter the data it worked. Can anybody explain why this is happening?

I have a large 5ish meg spreadsheet, into which project info is entered.
Once complete there is a function which opens a new workbook and then saves
it with the raw data in it, ie as a save file. which is much smaller.
I would like to add some code to the "Private Sub ...

I'm trying to find part numbers on one spreadsheet that are not on
another and create a list of those parts. Doable...?

I am attempting to read a workbook's properties such as Date1904.
Using brute force I discovered the flag in byte 765 of some .XLS
files, but I presume that the location is undocumented and unreliable
across all current and future versions of Excel.  I need to verify

I have a column with multi same entries and i want to count them as per
category.
So if  i have in colum b  same entries such as "category a" for 20 entries
in a column with 5000 entries and bring them by sort filter, how i can count

can I enter text as part of an excel  formula, eg: xxx boxes

I have a tax rate slab like
Sl.    Income                        Rate
1      1500 or Less                  Nil
2      1501 to 2000                 18

Using a worksheet function how would you copy the contents from say sheet 1
to sheet 2. For example: Sheet1 has a part number in Column a, A qty in
Column b, a date in Column c. Each time a part number, qty and date is
entered paste it to sheet 2 and keep going down each row ...

The problem is next I'm imoprting data from a database and this imported
data consists os from a date_time and value. the problem is next, the time
and date field isn't recognized as such and bacause of this my query to
select a specific date range doesn't work ,however when i ...

Excel 2003
I have a worksheet with many rows containing text and dates across columns.
Dates are entered using dd/mm/yyyy format and a slave hidden column converts
the date to a yyyy-mm-dd format.

I am using the formula =SUM('1:31'!K51) to get sum across multiple
sheets.
In cell
A1= 1