Is there a way to accomplish this feat??
cell data
"7004 Brookville Rd"
need the file by street name , then by number.

How do I format a cell in Excel to store Bar Codes
Some Barcode begin with Zero !
When I format them as a 'text' my linked table in access displays #NUM!
Error and if I run a query I get the same error.

hi..
i'm just tryin to make it so that when the user inserts a 'g', 'r', or
'y' into a cell, the font for that cell changes color appropriately..
this looks fine to me but nothing happens...

I have a range of cells in a spreadsheet containing values, say cell A1 : C5.
Example as follows:
        A            B            C
1      100         100         100

Hi, i am quite new to excell and require some help, i am trying to solve a
problem for a junior football team that i run. I have a list of 14 players
and require 9 to play at any one time thus leaving 5 subs. They play 4
quarters so i need so swap the players in each quarter making ...

An employee asked me if he had 3 files each containing the same database.
Is there anyway in which he can update the data by only keyboarding it into
one file and have it automatically update the rest of files?
Any help is appreciated.

I have an excel spreadsheet where questions are answered in one area,
and the answers show up on a form in another area of the sheet that
gets printed. Instead of printing, how can I either email the print
area or have just the print area saved as a file? And, with a macro,

I need to create 2 workbooks, which have data relationships.
I don't know how to get data connect when I change data in the first
workbook, this data will also be automatically changed in the second
workbook.

How do I get the value some colomn before (and after) ActiveCell.Value and
put in a cell
ex :
A1 = "UK"

How to separate - let say - 278.950 (in cell A1) become :
(B1)     2     pcs   of  100.000
(C1)     1     pc    of    50.000
(D1)     1     pc    of    20.000

I have built a spreadsheet which requires data to be entered in order
for the sheet to work properly.  My problem is even though there IS NOT
a blank option in the drop down, you can select the cell and hit
<delete>.  This effectively enters a "blank" entry and renders the

I am finding out that Excel 2000 is not doing a good job with filters
when it comes to cells with large amounts of text.
I just wanted to see if this is others' experience as well, not me
doing something wrong.

I'm working on a spreadsheet and have hit upon a problem. Due to an
extension in the range I am calculating my nested formula now exceeds
the magical 7 limit. I only actually need to add on more range to
calculate, but cannot work out what to do.

Too many sheets in one workbook
Hello everyone,
MY name is Peter.  I created 30 or 31 sheets in a workbook to represent
30 days in a month and another sheet to sum the amount of spending and

I've this message while saving the excel file even if no change ha
been done to the file. There is no share on this file (exclusive use)
File resides on a network drive
It's very disturbing