I have been given an extensive CSV file which has been created without a delimiting character !!! Thus, instead of records in columns in each row, each rows...

i want to insert clip art into a drop list instead of text

I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the format of ddmmmyy. I am trying to create two more columns of data, one containing...

This is probably very simple but I just don't see it. How can I see if a (variant) variable is a range or something else (e.g. a string) Sub WhatIsIt() Dim...

I have read previous messages and responses regarding maximum text length in cells, not visible on screen, or when printing. I am using Excel 2007, and have...

My worksheet is compressed to really tiny print when I print it to a printer or pdf Create. Only one tab is small print. I can not see anything in page...

Is there a way to count checkmarks ,, I have a sheet with lots of checkmarks in columns, I want to be able to have a count of the number of checkmarks in any...

Hello, I want the footer in my print-out to pull some information from my workbook (ideally from a different sheet) Is this possible? Thanks M

At home I have Excel 2007 student version. My boss has Excel 2007 commercial version. Can I work at home and transfer files to my boss's computer? My...

Every time I use the cut and paste method for moving items, the clip board opens on the right side. Is there a way for turning this option off?

I am using excel 2007. I have a spreadsheet that contains data: Acct no Date PPT Paid Sales Tax Amount 1000 4/30/10 60.46 4.54 ...

Hi, I need to have a function that will search a given worksheet (or a range of cells on a given worksheet) for a string and then report back the cell name...

I want to specify a text color as the look up value in the vLookup Formula. Is this possible? Do I need the code of the color? Thanks in...

Hi, I got four columns of stored list of addresses and dates (two for address and two for dates) which I want to match against each other. The formats of...

I am trying to pull certain characters based on a criteria for the third position character. In Column A, I could have a code such as BB11 or a Code such...

Spreadsheet filename no longer appears in the title bar of the spreadsheet window. What do I need to do to get the spreadsheet filename to appear? Thanks --...

I have been asked if it is possible to identify cells that have conditional formatting? is this possible? Thanks Steve

I am trying to share a workbook - Toolbar, Review/Share Workbook - Each time, I get a message, the file is no longer shared and will not let me save. Any...

Good morning please help i have a lists of names and i want to separate each in a colum like You Light Up My Life197711 You Light Up My Life (in one...

if i change this format 07/03/2009 to some other format through right click, and format cells - date - 07-mar-2009 but the change will be happen to this...