General

Formula to locate all jobs in Month then break up into categories
I have a workbook with a worksheet displaying all the jobs I have in different categories. I would like to display on the my worksheet "Nikkis Critical Data" a break up of jobs per month - Which I have done using =SUMPRODUCT(--(MONTH('Nikkis Working'!A2:A1000)=MONTH(A2)),--(YEAR('Nikkis Working'!A2:A1000)=YE... 22 Mar 2010 07:11

Problem in Conversion of Excel to Text(Tab delimated)
I am trying to convert excel file to Tab delimated text file.But if there is any comma in between any string then "" is automaticaly appearing in converted text file. E.g In my Excel file I have sting like Good,Morning In text file this is getting displayed as "Good.Morning" Can you please suggest me h... 22 Mar 2010 09:24

Cancel Read Only
Please tell me how to delete read only in msexcel. I need read/write. ... 23 Mar 2010 10:09

Problem With Text & number format
I hv this sample data in excel 019-1234567 019 1234567 019#1234567 %0191234567 My question 1) How to delete spacing, dashes, character etc leaving the number only..in my above sample the clean data that i want to get is 0191234567 2) I tried to use replace function (to delete dash,space etc) but the ... 22 Mar 2010 06:05

how to remove the page break lines in a spread sheet,
Can someone tell me how to change the view bakc to plain spreadsheet without page break lines. I cannot remove the lines with the remove page break because I did not insert page break, but i cannot tell how i got into this view and now i am stuck there. ... 22 Mar 2010 00:23

Problem With Excel 2007 - not responding and disply font changing to japanese
I was desperate in finding a settlement of the problem when I upgraded office excel 2003 to 2007. which becomes a problem only on microsoft excel course, not with any other office applications. problem like this. upgrade process is complete, but when I open the excel option, all of its dropdown font menu letters ... 21 Mar 2010 23:16

Can anyone tell me how to do a mail merge from Excel?
I have loaded 388 entries and now cannot figure out how to print to labels. Some have told me I had to copy and export from Word, but I don't understand how to do that. Help! ... 22 Mar 2010 11:53

HOW CAN I FIND what THE FUNCTION BUTTONS do?
... 22 Mar 2010 02:47

Can I flip a symbol?
I'm creating a form using Excel 2003. I want to have 'clip here' with the dotted line plus the scissor symbol at the beginning and end of the row. How do I flip the scissor symbol at the end of the row since it faces 'outward' and not 'inward?' -- Thank you. ... 21 Mar 2010 19:44

Can I flip a symbol?
-- Thank you. ... 23 Mar 2010 10:09