I would like to combine text from different cells that has formatting such as subscript/superscript which is removed upon concatenation. Does Excel have...

In my spreadsheet, users are prompted to enter a value into cell B4. Multiple peices of information are then returned based on what they entered, But certain...

Hi I have two cells, one containing first and middle name and another one with surname. I want to combine the first name and surname into a separate cell,...

When I press the / key the shortcut keys appear instead on the ribbon (only in Excel 2007, not Word 2007). However I can type / into the formula bar ok - it...

Dear all, Cell A1 contains a formula. How would I go about conditonally formatting A1 such that the cell will be filled if the formula is overwritten by a...

In a predesigned workbook, I was entering a date in a cell but it would default to the general format. I tried changing the format in the cells dialog box...

There are two ways to put a password on an Excel workbook - one is through Prepare Encrypt and the other through the Tools menu in the Save As dialog box....

Using the following array formula I am identifying the top five largest points scores with specific...

I was told that I could manage data with Excel that would be related to customer information but I have no idea how to get started. Does anyone have any...

Excel2003 ... WS1 ... Row Range L2:Z2 ... Contains Text WS2 ... Col Range B3:B17 ... I wish formula to populate Text from WS1 == I know I can do this with...

My shared workbook now says it is made "exclusive" by me and I can no longer implement sharing. How can I fix this. It is linked to Access and some...

I am currently working on a spreadsheet where I need to solve two problems both of which I think can be done with Sumproduct but unfortunately I am having...

To convert a text value to a number using a defined rule in Excel, say a macro or some other formula? Take for example, say the value "Instructor" mapping to...

How would I write a script or macro to display rows that have and x in "A" and hide all other rows? Thank you

I am sent an Excel spreadsheet each week that I copy and paste and add to a main worksheet. The size of the file is getting huge. I discovered the reason...

I am trying to create name tags with pictures using label # 5384 I do not understand the MS instructions, nor do I see where I can insert pictures. I have...

Hi - have a single worksheet on which I can use Custom Views to show/hide different columns etc as I need. However, can I save a Sort order with each View as...

I run a hockey draft that requires me to copy worksheets into a master sheet but I need to know how to copy them without the formulas referencing the...

I have 2 branch office budgets that I would like to merge into one consolidated master budget. I would like the branch budgets linked to the master budget so...

I want to apply a print range to multiple worksheets in the same workbook. The data area in all the worksheets is the same & I'd like to know if there is an...