life

i have to parse out a text string that is 500 characters long . . . (no delimiters, just positional data). but a lot of the data is blank. My text string is in column A, starting in Row 2 and in cell B2, i want to put a simple formula, =LEFT(A1,X), where X the number i type into C1. This will...

Hi Everyone I am after one huge favour around 300 sheets coming into me at some point next week for a Salary Review. I need a way to be able to unlock all of the workbooks in one folder (same password), unprotect them all (save passsword) and then copy and paste the data from the columns A-Q...

Hi I am looking for scenarios (how do this or that in excel ) and or real life simple examples/solutions in excel. I learn better by examples. Seeing how other people done it and try to understand how they done it. I tried google but did not find what I am looking for. Maybe I do not know how...

Hi... Pls help me with the following.... A LED light producer tested the life of 30 samples. The question asked to find minimum and maximum LED light life by using spreadsheet formula, which I did. Then, I am stuck when it asked to Find the percentage of LED lights which have less than mean life.

Hi So I have a waterfall chart. And here is the data: Want I want to have is the bars to the right of the black target column to descend, not ascend, to the point where they meet the final gray column. I have both the black and gray column set as "total". For the life of me I can't work...

I have a rather large and complicated spreadsheet that has developed an odd behavior. It will stop for no reason on the same line of code. A simple F5 command will start it back up again, but I can not for the life of me figure out why. It's acting as though a STOP commas were in the code but...