| Thread | Last Post | Replies |
|
| Change firstname lastname to lastname first name in a column | 31 May 2004 23:21 GMT | 3 |
Hi, I have an excel spreadsheet where I have a column of user names an they are listing as Mary Jones, Tim Betts etc. There is a spac between the First Name and Last Name. I would like to change thi column to show Jones, Mary and Betts, Tim. So lastname, firstname. I
|
| Getting text to appear in another cell | 31 May 2004 22:35 GMT | 3 |
I am using Excel 2003. There maybe a simple solution for this, but being very new to Excel I am struggling a bit and would be grateful for any help. I am developing a horse tracking spreadsheet. What I want to do is create a formula that does the following:
|
| Problems with array | 31 May 2004 21:59 GMT | 5 |
I have been trying for awhile now in fixing this problem that I am having with this array and since I am getting no where I thought I might ask here for some help. Here is what I have: date time day evening night 24hrs.
|
| Excel | 31 May 2004 21:59 GMT | 2 |
I have trained myself to use Excel but I'm having trouble with revised a spreadsheet that was created by someone else (probably someone who knew what they were doing!). Within a cell, I need to add a line or lines between text.
|
| FORMULA | 31 May 2004 21:57 GMT | 3 |
I can calculate the sum of a column of numbers (even though some cells within the column are not numbers but text) and I receive the correct figure. HOWEVER, when I apply this to a ROW, the SUM cells displays #VALUE! Why
|
| Help with code | 31 May 2004 21:21 GMT | 1 |
I have created and coded text-boxes ( using the design view and VB-code) in excel that enables me to jump from one text-box to anoter by using the Tab-button, but view of the worksheet does not follow the tab Then I got at tip to add code to Select or GoTo a nearby cell before the ...
|
| Viewing two parts of same sheet at once | 31 May 2004 20:16 GMT | 4 |
I am using Excel 2000. I need to view two parts of the same sheet at the same time. Help tells me to put my mouse at the top of the vertical scroll bar, and point to the split box, then
|
| text alignment in cells | 31 May 2004 20:15 GMT | 7 |
I have been using Quattro Pro, and am learning Excell now. I have entered data in four cells in a row vertically down the same column (i.e. A1, A2, A3, A4). I selected those four cells, and clicked to have them all right hand
|
| file conversion | 31 May 2004 18:57 GMT | 3 |
i have an old spreadsheet program called supercalc. is the anyway to convert this over to excel?
|
| Problem adding up | 31 May 2004 17:45 GMT | 10 |
I have number data in cell C2 to C19 which i want to add up. when i enter the formula =SUM(C2:C19) i get the answer zero. I cant make out why. I wonder any virus or corruption is the cause or my i making any mistake. I apreciate any suggestions. Thanks. sr
|
| deleting the repeating content | 31 May 2004 17:22 GMT | 3 |
hi, I have some name like this To Jimm Jimm
|
| Previewing the pages to be printed from a help topic | 31 May 2004 16:09 GMT | 1 |
I need help on the above subject.just to know the number of pages to be printed in order not to be out of paper I have window XP professional it does not work either oe EXCEL2002 and/or WORD200 many thanks in advanc
|
| Relative formatting | 31 May 2004 15:52 GMT | 1 |
I created an excel file which extracts information from several workbooks. In one column, the addressing is relative (i.e.: ='[file_name1.xls]Spreadsheet_name'!$B$25), while in other columns the address is absolute (i.e.: ='C:\Documents and Settings\SaarB\My
|
| finding next business day of end date | 31 May 2004 15:33 GMT | 7 |
Can anyone help me with this? If I enter a date, for example, 5/20/04 in cell A1, I want cells A2 to A11 to show the same date in sucessive months (6/20/04, 7/20/04, etc) such as with the edate() function.
|
| Excel to Quatro | 31 May 2004 13:10 GMT | 2 |
Sorry if this has been asked before but I have sent an excel file to someone running Coral Quattro Pro (which I have never heard of) and when they received my file they said that there were figures missing and stars or 0's showing up!
|