CHAR(10) does not create new line in excel 200741711 (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 Gridlines3470 (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.2169 (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 sheet21196 (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 spreadsheet2333 (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 Sheet0158 (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 working4851 (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 horizontal2616 (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
numbertowords2348 (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 workbook1214 (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