How do I get all narrative to fit into one cell block? I handle moves of sites. There is one field that requires some fairly extensive explanation of any issues that have occurred for history purposes. I have discovered that excel will cut off at a certain amount of data. If you click on the excel box you can see all the data. However, when it prints and when yo... 21 May 2010 17:15 Average a column that contains one cell of text What formula do I use to average a column of numbers that contain one cell with text? I'm using Excel 2007 ... 21 May 2010 10:37 Average columns that contain text What formula can I use to average a column of numbers that has one cell containing text? ... 21 May 2010 10:37 condditional farmulation sir, i want to do in excel such type of farmla through we can not leave blank cell or enter without giving number. like : 1 2 4 if we can not enter 3 than cursor is not enter in next cell ... 23 May 2010 00:42 WHEN I TOTAL A COLUMN I GET A RESULT IN WRONG FORMAT I am working on sheet 2 and when i try to get the total i get what looks like a date instead of total. I have tried copying the group to another sheet and it works fine but i don't want to copy the whole sheet. Help! ... 21 May 2010 06:14 Combine various cells in to one array On Thu, 20 May 2010 20:38:45 +0100, Odin wrote: I have the following formula that I would like to shorten it. Is it possible? =12.5%*((\$A\$1=\$C1)+((\$A\$1=\$C6)*2)+((\$A\$1=\$C11)*3)+((\$A\$1=\$C16)*4)+((\$A\$1=\$C21)*5)) To following is just an idea but doesn't work on excel. ... 21 May 2010 01:56 converting db need six digit w leading zeros, I need to have a six digit value for an ID field. Old db has values ranging from one to four characters and need to front fill with zeros ... 21 May 2010 01:56 VLOOKUP and IF formula I have this formula already in use... =VLOOKUP(B17,'[DSL UVERSE CLOSE RATES - APR 10.xlsx]Pivot'!\$A\$2:\$C\$291,2,FALSE) I need it to include an "If" formula as well returning a "-" dash if it cannot find the name on b17 in the file it's looking up. Any help is appreciated. ... 20 May 2010 19:26 Data Validation I have a drop down with data validation and I'm trying to compare names from two name ranges. The first name range is called NameCheck, it has the names of all my employees. The second name range is called Monday and that has the names of the people who are off on Monday. I need the names of the people who wo... 21 May 2010 11:43 Count the words in a cell Dear exper A cell contains a lot of information. Is it possible to count certan word in a cell please? Say A1 contains a series of text .... 1. Daily Swing even though Sto is hit high or low 2. Look at Chart pattern 3. Stop at dangerous level How can I count number of "O" in the cell A1 please? Thank... 20 May 2010 17:14