I have several data with this format: 1 test.msn.com/dfsmnfkmnfdf 1 test.msn.com/defgfdhrh How can I rearrange them to look like this...

I have an Excel 2007 document which I used the Page Layout/Header option to set up the heading. The heading does not show unless I take the print preview...

Hi, I am trying to find a value in the follwoing sheet "AO1 1-2009". I want to find the number 500 and put it in another sheet. A B C 1 ...

Sorry for posting if this is alread addressed here, just couldn't figure out how I'd go about finding it. I have a pivot table. Two items in the PivotTable...

Hi friends; I’m new in Excel and I have a large data file. One Cell in the data file is messed up. I would like to split or separate the contents of that...

When I select a cell in Excel, it often happened that a number of adjacent cells (horizontally or vertically) are also automatically selected. I must then...

How can I match abbreviations in a cell to a list of words and return their values if the text is various word lengths and I need to match each word? Thanks.

I have a range of data in two columns with anywhere between 1 and 144 rows of data. Data in Column A is in text format and contains all unique data. Data...

I'm haveing a problem with the following code to clear the contents of controls on a UserForm. Sub ClearForm() Dim Ctl as Control For Each Ctl in...

User accesses file on network via Windows Explorer, gets a "File in Use" dialog indicating he already has the file open, which is false. User clears dialog...

How a Row cans shifted to another location in the same Worksheet after change a cell value. Note: there is no reference in the Row but it has as certain text.

I have created a form in Excel and want to have a button to mail it as an attachment when completed to a specific return address. Hyperlink to an email...

I have a Excel 2003 spreadsheed with conditional formatting: a cell changes from red, to green, to yellow, depending on the value entered into the cell -- it...

when printing i know how to put a page number on a worksheet but i am unable to put a number of the number of pages in the footer or header

I have cells with various amounts of numbers in them. For example, d6 has {0, 3, 6, 9} while d9 has {1, 3, 4, 7}. I'd like to count the number of times the...

When I clear the Filtter that data will not go back as in the order that I write it.

HI I WOULD LIKE TO COUNT VALUES BETWEEN A RANGE. THE FORMULA I HAVE TRIED TO USE IS: COUNTIF(D:D,"30000AND75000") TO GET THE NUMBER OF VALUES BETWEEN 30...

Hi I have a worksheet of various transactions sorted in date order. There may be 1 row of data for a specific date if there was only one transaction and...

Problem: I have name and address in two Cell A5 and B5 respectively. I obtain an alert in cell G5. Once the alert is envoked, I want to click on that cell...

I am aware that you can produce multiple instances of the same form in VB6, but can this be achieved in Excel vba. I need to enter the contents of numerous...