Want to use Ctrl-H to replace a specific character in a range of cells with a line break (Alt+Enter) - how do I access special characters? (^p didn't work)

Hi all, Is there a way to convert this date string OCT 23'08 6:04PM into serial that Excel will recognize as a number instead of a string? Thanks! goss

I am trying to copy a multicolumn table to my spreadsheet; However, for about 5 of the fifteen columns, I get a "DATE", such as ...

How Do I use SUMIF A:A = "Apple" and B:B = 50% then sum C:C Let me know if there is other solution other then SUMIF also

hi, I have a script trying to add, have a prolem with: - inserting as a sub, my incorrect labelling?, (problem: using button for item below the XXX's...

I have a spreadsheet that contains a column that has numbers and text of varying lengths that I need to split into 2 columns. Example: 123John Doe ...

I have opened a htm data set in Excel 2003 that contains the date & time as yyyymmddhhmm (the cell is formatted as general) and need it to display as...

Hi: I have a calendar in a spreadsheet. I record by week the vacations days and sick days. In cell A I would like to get the sum of all the cells that...

We transfer data from a database to Excel for multiple reasons. The ID to our records are 6 characters such as "123A12" "456B12". When we have an ID such...

I have a forumla where I'm looking up a Client name and finding all the contacts that relate to that Client. The most contacts per Client is 8. This formula...

Hi, i need the date and day in C1, but only when i write something in C8. And when i close the workbook, and open it again, the date to remain the...

I have a column of dates and a column of durations. I have used a pivot table to work out the average duration by month. However, I also need to calculate...

I am getting a #VALUE error when trying to add a series of data in different cells. Apparently this is due to an "inconsistent formula" with others in the...

Hi I would like to enter time into a timesheet using the decimal point instead of the colon as it makes it easier and quicker to type, however I still want...

The 'Tab Color' menu item is disabled on the Format menu and also when I right click the tab name. There are no disabled items (Help-About Microsoft Office...

My vlookup formula goes like this...

trying to select every other 1st column, of 2 columns sets. 20 columns, 10 sets. only use one at a time for formula trying to make. using fixed cell $C$2 to...

Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions...

Hello I'm guessing this isn't allowed but I'd welcome confirmation Can one concatenate a variable into a VBA command So for example instead of userform1....

I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need...