CHAR(10) does not create new line in excel 2007 4 1711 (12/23/2009 4:50:01 PM)
I am copying contents from multiple cells into one cell, I would like a new line for each cell content being copied. I use the following forumula and do not see a new line being created. I found this on m...
Utf

Restoring Gridlines 3 470 (12/23/2009 3:48:05 PM)
In an Excel 2000 spreadsheet I inserted some rows and deleted some cells. The gridlines in these inserted or deleted and restored cells lack gridlines. I tried to restore them using Format->Cells->Border, b...
Abradaxis

Removing protections that prevent me from editing formulas. 2 169 (12/23/2009 4:11:01 PM)
I am trying to modify an Excel Workbook that I received from my company. When I try to change formulas in the workbook I get the following error: "The cell you are trying to type into contains a formula and...
Utf

convert repeated sheet 1 names to once in sheet2 1 196 (12/23/2009 1:17:01 PM)
i have a work sheet contained name with score, in that sheet names are repeating scores also repeated but values are change( ex: a=10, b= 6, c= 2, a= 18, b= 1, c= 8, a =1) in the sheet 2 i want only once...
Utf

World Cup 2010 spreadsheet 2 333 (12/22/2009 6:40:01 PM)
Hi All & Happy Christmas & New Year, I'm working on a World Cup 2010 spreadsheet. I've got the group tables & matches sorted out but my problem is as follows..... In the group tables I've got the Played,...
Utf

Single Weekly Time Sheet 0 158 (12/23/2009 3:46:01 PM)
Good morning, I am having a problem with time sheet reporting. We have a weekly timesheet which hourly employees complete every week. Most have been saving EACH timesheet. That is 52 timesheet tabs. Wh...
Utf

Trim and Substitute not working 4 851 (12/23/2009 9:12:01 AM)
I have this excel with the following data in column A '1234567891234545 236556545454554554 '45454545455458475258 4845487845155484844 4848745125154545454 I want to do the following: 1) remove ...
Utf

convert vertical to horizontal 2 616 (12/23/2009 11:05:29 AM)
WE HAVE VERTICAL LINE OF NUMBER AND WE WANT TO CONVERT IN HORIZONTAL LINE.PLEASE GIVE SHORT CUT FORMULA EXT: 1 2 3 4 5 6 7 8 9 10 Please convert in horizontal line. Submitt...
AMIT

numbertowords 2 348 (12/23/2009 8:36:01 AM)
Hi Friends, please let me know how to use the function Numbertowords in excel. for example we can convert $ 1,256. as one thousand two hundred & fifty six dollars using this function. thank you. ...
Utf

Cannot open text workbook 1 214 (12/22/2009 6:34:02 PM)
i am using the following code to open two txt files that open fine in notepad: Workbooks.OpenText "C:\Orders\" & Range("B2"), Origin:= _ xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldIn...
Utf