I have a table setup already, but realized that on field requires I add
'CEP' to the beginning of the values in 1444 fields (same column). I
don't want to go through field by field and paste, is there a way to
merge values or join fields . . . etc?

My recent foray into automating excel via its com interface went fine as far
as the program is concerned. Unfortunately, somewhere along the way I've
messed up its ability to function interactively from my desktop. In
particular, when I double click on a xls file in Windows ...

I am trying to acquire advance skills in ms-excel that will help me in my
daily job.

Is there a way to make the default for a cell comment property to "move but
don't size with cells"?  At present I have to go to properties every time I
add a comment.
Beemer

Sorry about this Roger,
I tried this
but...=IF(AI13&AW13&BI13&BW13&CJ13="N","",IF(AI13&AW13&BI13&BW13&CJ13="R","",SUM(AI13/100)+(AW13/100)+(BI13/100)+(BW13/100)+(CJ13/100)))
The cell I'm putting this formula into is L13. However, I still get that

Ok... I have to edit this worksheet for shipping every day I have to put in
an item #..which then relates to a SKU and shipping method... Is there any
way I can get these to automatically pop up...
For example Item 1 = (SKU) 099999 (desc)single  (Shipping Method)UPS Ground

I have a spreadsheet with five columns that I enter data to. I then
have a blank row at the bottom of these columns.  Below the blank row I
have several formulas pertaining to each row.  How do I add more data
to the columns and have the formulas adjust for these new rows without

Not sure if this is possible but have named cells a1:a8 named as test01
what i want to do is in formulas be able to use =countif(test01+ 4
colomns),"Test")
eg want to be able to use say e1:e8 in a formula but not have to use

Noob alert :)
I have a workbook containing several worksheets.  I will  be adding another
worksheet that will, in effect, be a master for all of the other worksheets.
In the source worksheets (existing) there will be several employee id's

I will try to express myself clearly but I might not be able to fully do so:
I have a 22 page worksheet with each page as a technical data sheet.
When i print these, the text is fine but the size of the main outline border
is different on the different pages---in other words, the ...

I am trying to do a grouping in my pivot table and a error message comes
back that I cannot group the data. The data is a date field and I am trying
to group as a month or quarter. I think the cell format may have something
to do with the problem but I have formated it to a date ...

Can I force excel to use the exact value obtained by multiplying a number
which has six decimal places rounded to three places by a constant rather
than the value got by using the full six places in the calculation?
eg 1.105566 x 24 = 26.533484 but 1.106 x 24 = 26.544.  I'm a ...

I type in "$1,819,000,000,000" and it always turns into,"1,819,000,000,000"
How do you stop it?
I type in "$4,422,200,000,000" and it alwasys turns
into,"$4,422,200,000,000.00"

I put in a formula to combine a string of words with numbers and would like a
space or dash to go in between.  How do I do this?

been a while since ive been on here!
I am trying to work out a tricky formula...I will attempt to paste an
example below but it will probably go out of alignment so will also
attempt to explain.