Functions

Splitting Text from single cell in column across multiple Columns
Text To column wont work because I have name and address info in a single cell in this format. Each cell has different data representing different addresses. Name St # St Name Phone Number City, State zip I want a formula or something to take first line and put in one column, the 2nd line in another colu... 14 Mar 2010 07:38

I can still select & manipulate locked & protected cells in '07
I have an Excel 2007 worksheet that rotates between locked and unlocked rows. I protect the document correctly (checking the boxes “select unlocked cells” & “format cells”), but I am still able to indirectly select and manipulate the locked cells. To do this I select an unprotected cell and drag the cursor vert... 12 Mar 2010 15:05

Hiding worksheets
Is there any way to keep users from un-hiding worksheets in a workbook? However they do require access to other sheets (not hiiden) within the workbook Thanks -- ce ... 12 Mar 2010 16:12

External Links in Excel 2007 with variable source file
PaHead, can you please post an example or send me a sample file? "PaHead" wrote: Dear Ron, Thank you very much for your reply. It has solved my problem completely with the extra use of SETV and GETV. Your answer was invaluable. I can post an example of what I have done if anyone ... 12 Mar 2010 15:05

Repeat Rows but not on every page!
Is it possible to set the repeat for just a certain number of pages, not all? Example: I want to repeat $2:$2 on page 1 through 6 but I don't want the repeat on pages 7 through 10. Is there a way to define this? ... 12 Mar 2010 13:56

Creating a new table from another - filtering out unwanted data
Here is my table for sheet1: Shipment No. Product No. of Pieces A pencil 1 B pen 1 A eraser 1 A paper clip 2 B stamp 3 C rul... 14 Mar 2010 07:38

How do I lock ONLY the formatting on an excel sheet?
I want to Lock the formatting on an excel sheet so when i sort the data in the sheet the background colors and cell formatting stay in place, and just the data shifts. Is this possible? ... 12 Mar 2010 20:43

Reconstructing a table
I can pull a table out of a repository that looks like this -- Bill Mike Sarah Jill Tom Project 1 0 10 0 0 0 Project 2 40 0 0 12 0 Project 3 15 0 0 0 0 Project 4 0 0 5 0 15 I need to create some formulas to switch the table to look like -- Project 1 Mike 10 Project 2 Bill 40 Project 2 Jill 12 Project... 12 Mar 2010 19:34

colating multi rows of data into single rows - no to pivot tab
Roger, thanks for input. I did try sending you part of the spreadsheet so you could see the design etc but got a bounce back on your email address. :( My layout does have seperate areas which your formula collates the data from simula to what you suggest. If you want to email my UKMAN1(a)hotmail.com address I... 12 Mar 2010 11:41

SUMIF with area that is not a range
I am trying to sumif cells that are not consecutive. Here is what I have so far: =IF((I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,DI8),"paid",(I8+Q8+Y8+AG8+AO8+AW8+BE8+BM8+BU8+CC8+CK8+CS8+DA8+DI8)) These cells need a sum: I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,DI8 if "paid" ... 12 Mar 2010 11:41