Hello all
I was hoping someone could provide me with some help with excel.
I have a cell which has 30m557y in it i want to seperate the contents of the cell so that the
30m is put into a seperate cell but with no m attached to it
& the
557y is put into a seperate cell but with no y attached...
I would like to copy (to a folder) or attached pictures inserted in an excel sheet ( a price list) but i can't copy it to another folder or even attach it to my yahoo inbox to send it by email.
Please advise
I would like to copy (to a folder) or attached pictures inserted in an excel sheet ( a price list) but i can't copy it to another folder or even attach it to my yahoo inbox to send it by email.
Please advise
If not, does 2007 version support it?
I am trying to import an XML file from remote server, then layout the data. I can import the XML file, but currently cannot understand how to adjust the layout of repeatable elements.
If not, does 2007 version support it?
I am trying to import an XML file from remote server, then layout the data. I can import the XML file, but currently cannot understand how to adjust the layout of repeatable elements.
...with a condition? Suppose, my Column, A1 to A45 is numbers 1, 2 and 3.
My column B1 to B45 are words like dogs and cats.
I need to total the criteria between A1-A45 and B1 to B45, where dog(Column B) and 1(column A) match or cats and 1 match. Need to total them. What is a formula I could use?
I know this is probably a dumb question, but I know there is a keyboard shortcut that is simple to use to quickly close a workbook that doesn't exit the Excel application like Alt-F4 does. I can't remember what it is or how to find it,
I have a template I downloaded and put into excel and its to keep track, i just rather have one large file for each week then have individual ones, so how can i copy the same tamplate into the same file mutiple times?
I changed classic Windows XP visual style using "uxtheme" patch. New visual style changed format of some cells in Microsoft excel. Colour of some cells or cell borders differs according to which visual style is set. Is it possible to disable visual style to affect specific application (e.g...
I need to be able to reference the equation of the trend line obtained on a graph in Microsoft Excel 2007.
I know I can just type the equation but my instructor would like the whole process to be automatic. Just change the values and everything should change with it. Including data which relies...
I have an excel program which has a lot of data entry, nearly half of the row(30000) was fulfilled. The program has front menu page. From this page I create a data which should be log into the row of 30001(below the next row). However, if i didn't have that much of data, i knew, it would not be...
...to edit it? I have an excel file in a shared folder at work and everyone needs to be able to see the information but there should not be anyone editing it except me. I thought I had it set up that way but found out yesterday that was not the case. Is there a way to do this? Also is there a...
Hi
I have an Excel exam coming up and our lecturer doesnt give any sheets on formulas or anything like that. I was looking for some websites to help me or to have some exercieses on them but cant find any.
Would anyone know of any good websites for help with excel???
Thanks
I have a document that I need to delete the SAME rows, delete the same columns, copy the date from one location to another, and then auto-fill...Certainly a macro can help me with this right? I'm self taught in Excel, but very proficient. Point me in the right direction, anyone?
If column A is "e-mail addresses we have for customers" and column B is "e-mail addresses we know are bad." How do I filter for items that are ONLY in list A so that we end up with a list of only good e-mail addresses?
I already tried "unique results only" but that's not what I need. "Remove...
I have scanned a document. It is a table with letters and numbers. It's showing up as a picture in Adobe Acrobat 7.0 Standard and won't let me run OCR. But I need to convert it to a spreadsheet in Excel so I can further analyse it.
Is there a way to do this?