Summary: Hello I have a succession of contact data in the form of: NAME, A.B. Address Address Address Address Phone: 000-000 Fax: 000-000 E-Mail: aaaaa@mts.ne...
Summary: Hi, I am new to the macros & programs I have a excel 2007 file, in that there are 43 rows, on 43rd row the total comes, now i want a seperate row & to...
Summary: I have a SIMILAR QUESTION, but it's more complicated (maybe). I keep running into problems with the "text to column" converter, when it comes to con...
Summary: hi all, one of my client computer containing outlook express not supporting excel rows and columns when i am copying any excel documents in outlook.ho...
Summary: Hello, Anybody know how to change the the data from rows into columns or say in the other word is to rotate a table in MS Excel? Thank you very much. ...
Summary: I recently did a survey for a grad school project, and my results were rolled up in Excel. For questions where more than 1 answer could be given, the ...
Summary: Hi, I want to convert rows into columns in excel sheet. I tried copy the Data,paste it special. But it doesn't give me the format I want. This is the ...
Summary: This is great advice, however there is one problem... For this to work time in and time out must be set in military time. Is there a way to have a c...
Summary: "linking data to columns and cells that havent been created yet."i Have an excel sheet that has totals that need to be carried to other sheets. Curren...
Summary: I've been using MS Exchange, Office 2003. Now I'm using MS Outlook POP3, Office 2007. The file I exported from exchange has an extension .osd and I ca...
Summary: Hi All, Can someone help me ouit it this?? Objective: Import of data from .txt format to excel. Problem: I have tried importing the text file in-to ex...
Summary: 1 - In B1 enter: =IF(LEFT(A1,6)="Supply",A2,"") 2 - Drag this down to the bottom of your data 3 - Edit...Copy...Edit...Paste Special...Values 4 - Data...
Summary: The text does not have to be the same but spaces need to be between the second and last header. The txt file should have fixed lengths as well. I ac...
Summary: I am sorry, I did not make this clear. Actually, what I am trying to accomplish is to automate the creation of the 'cartesian product' of rows and col...
Summary: Allow me to clarify. I can view the document in Microsoft word 2000. Viewing is not a problem. But I need to extract the data from the label format in...
Summary: I need some help in MS Excel. What I need is to be able to switch between the row and column headers. I'm sure there is such a function although I h...
Summary: I do not know how to do that but in this scenario I would use the Sort function and then delete the unneeded rows. But, the wonderful and free Excel a...
Summary: i am having trouble converting works files into excel files. i have tried opening in excel and then saving as .xls but when i look for .wks in the "f...
Summary: Hi, I have a problem, I have a column (lets say column A) in Excel that contains data of type date, I converted it to date using the formula DateValue...
Summary: Is there a plugin or update available that will enable Excel 2000 to open a spreadsheet file that was created by corel Quatro Pro 9? I no longer have ...
Summary: Also look here: http://xl.barasch.com/cCo11432.htm As written, SpellNumber() converts things like 56.67 to: Fifty Six Dollars and Sixty Seven Cents bu...
Summary: I have several large trade blotters I exported from our portfolio trading platform. Problem is, with the date, when it exports to excel, it exports t...
Summary: I'm only concerned about the 1st 2 columns, if there's anything after column b it doesn't matter. I only want the row to stay if the 1st 2 columns hav...