General

CSV File
Just downloaded my cell phone phonebook as a CSV file. What an ugly mess. Each piece of data is separated by a ";". I would like to take each piece of data between the semi-colons and place it into its own cell. Please help with a macro or other advice. Thanks Phil ... 5 Jul 2008 23:45

How to return to previous cell?
Is there any combination of keys to return to the previous cell that the cursor was last on? For example, I click on a cell to look at the info, the go a few pages down and click on another cell. Is there a way to get back to the previous cell my cursor was on? ... 6 Jul 2008 12:59

How do I copy and edit photos received in an excel spreadsheet
I am using Excel 2007. How can I copy photos that have been received within a spreadsheet into a folder where I can edit them? ... 6 Jul 2008 08:54

using Sum Function
hi community when I use the Sum() to add a range and within the range of cells there is 1 cell that has Text data and the output of the Sum() function does not display the #value! error however when I used the "=" and added up all the cells the output display the #value! error can someone kindly enlighten me... 5 Jul 2008 22:43

Trouble opening xlsx with 2007
Hello. My problem is that I have Microsoft Office 2007, but it will not let me open xlsx files. When I try to open it...my WinRAR opens like when I open zipped files. It shows a _rels folder, a docProps folder, xl folder, and XLM document. If anyone could help me figure this out I would appreciate it. Than... 7 Jul 2008 09:24

Text copying disabled.
All of a sudden, when I now try to use my Control V to cut and paste - Excel puts a message in the cell that says "Text copying disabled.". It is probably something very simple - but I do not know... ... 5 Jul 2008 19:40

Preventing Changing Formula's
Is there a way you can place a lock on a cell to prevent removing or changing a formula. If so how do you apply it and also take it off? ... 5 Jul 2008 20:41

protecting specific columns in a worksheet
How can I protect two columns in a sheet. Eg. I could enter data in any cell except in the cells of colums K and M. -- Many Thanks. Regards, ... 7 Jul 2008 01:15

Letter = Number
When I type in certain letters, I need them to be displayed as certain numbers, i.e., MJ = 01, HS = 02, SE = 03, etc. I'm not very good with formulas, so any help is appreciated. Thanks in advance! :) ... 7 Jul 2008 00:14

whole numbers plus a percentage
If c4 is $1,500 and I want to add c5 4.845% to get sum of the two in c6. ... 5 Jul 2008 13:32