Trying to combine a worksheet with rows of data with a "formal"
Excel report (separate sheet).
The data work sheet looks like
A        B        C                   D

I wanto to hyperlink only a word in a paragraph. This paragraph is inside a
cell. I do not want to hyperlink the whole cell because I need to hyperlink
only a word. Example,
THE FENCE POST CREW PLACED 8 CY CLASS B, MIX C5321(JOBE). A REVIEW OF THE

I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as
"12345".
WITHOUT adding the apostrophe "'00012345" , how else can i get it to display
the zeros in front of the numbers (because it's text, not numeric)?

When using pivot tables, we have a task number for each job and have tried
various formatting options (text, number).  The taks number generally is up
to 3 digits and 1 decimal place.  The pivot table sorts the single digits
(1-9)

Its a little embarrassing asking something so seemingly simple but for the
life of me I can not figure this out.  I just installed Excel 2003 on a
computer and whenever I input a number without specifying a decimal it
automatically puts on in two spaces to the left.  For example ...

I have a spreadsheet that has a varying number of rows to print depending on
the amount of data. The columns are standard A:F but the rows could be 3 or
33. I have had a couple of goes but can't get it to play. Columns >F have
data but don't print.

I need to use multiple instances of IF/Then formulas in one cell. How would
I do this?
Here's the situation, so that you might get a better understanding:
I have one cell where a contractors name appears on a sheet. We use multiple

. "I'm trying to use the RANK function to sort the values in Column A, but,
the problem arises when I have two or more cells with the same value. Then,
the RANK also repeats some positions. For example, if I have, 50, 60, 62, 62,
67 in Column A I would get 5,4,2,2,1 in Column B. ...

I am fluent in Excel and have a strange line that I can't get rid of.  I have
created a dashboard type report and in the middle there is a line that runs
between two rows.  I want to delete it.  I tried to format the cells with no
line (there isn't one showing), I tried to grab ...

How can I take data that is in three columns, 180 rows and make it 6 columns,
90 rows?

What breeds of horses are there?

Hi team
Ive a sheet at work with the names of patients & wich room they are
in. I count the 'census' with sum product:
=SUMPRODUCT(--(LEN(A1:A10)>=2),--(LEN(A1:A10)<=30))

I need to be able to link PDF documents into an excel spreadsheet.  This can
be done via a hyperlink, however the end user does not reside on our network
server and cannot retrieve the links.  We cannot give read only access to the
server either.

Hi team
I have a roster (they call it a rota here in the UK)
Row  A: days along the top, monday to sunday for 28 days.
Row  B,C,D staff members & their shifts along each row

I have a worksheet that has all of my inventory part numbers in column A.  I
am using a lookup function requesting that on worksheet 2 it lookup the
partnumber and return the number of units sold in Jan 2007.  If the part
number is not on the Jan 2007 page the formula is picking ...