I have a text string in Excel that contains percentage values taken
from different cells.  However, the text string reads the percentage
value and outputs it as a decimal:
Percent defects of 0.678276052493135, 0.674664937815204 and

I have a column that I have a formula in.  I want to take the results of the
formula and copy it into a new column so I can copy it as text.   Thanks.

As suggested from a previous post I am using the following formula to fill a
merged cell.
="(AO) "&'Source Doc'!B49&REPT(" ",49-LEN('Source Doc'!B49&'Source
Doc'!C49))&'Source Doc'!C49

As far as I understand TRUNC will truncate a figure to either the integer or
a specified number of decimal places.  This can also be done by INT and
ROUND (respectively).  It is possible that TRUNC is provided as a duplicate
method but it may do something different - or in a ...

Please excuse my ignorance.
I'm trying to use the following macro to remove carriage returns ( and other
characters) from a list of addresses.
Carriage Return & Line Feed Clean-up Macro

I am having trouble getting my code for copying worksheets from one
workbook to another to work.  Here is my code in its entirety:
Sub Save_Report()
Dim rngAllFiles(), rngSelectFiles(), m, fileSaveName, wkshtName As

I have a worksheet, using 1845 rows and columns out to AB.  We use the
AutoFilter command on the Data menu constantly, and are getting a strange
behaviour.
When the filter is applied, it shows the appropriate data, but hides all the

How would I calculate the average of a series of cells having a formula
where the result is >0? i.e. ((G5-E5) + (S5-Q5))/ Total events
Or do I have to calculate the end result to a new cell prior to finding the
average?

When copying formulas, the $ sign stops excel from changing to the next
column letter. Is there a symbol to force excel to change to the next
letter?
Thank You

I input PPTED1 in a cell, but it just shows the last character 1 in print
preview.
Please help.  Thank you.

I have a VBA function in Excel that I have been using for years that will
display the sheet name in a cell. The VBA function is as follows:
Function SheetName() As String
  Application.Volatile

I would like a macro that would print all excel files (some with
multiple tabs) in a folder, and it's subfolders, based on a few
criteria.
Criteria:

I have a spreadsheet where I need to calculate a range of time in a
cell and display a value in another cell.
Example is in cell F2 I have a time displayed of 15:34, and in the
calculation window it displays as 3:34:00 PM. In Cell F3 I want to

I have a work sheet that has a cell that consists of 5 cells across . The
cell gets it's data from another cell. Is their anyway to get the cell to
make part of the text go extreme left and the other portion extreme right?
=sheet1!C1 & Sheet1!C2