love

Greetings from india! I have a problem with my worksheets. Sometimes I may come across a sheet with formatting that will simply never go away no matter what I try. I'm talking about numerical formatting. Is there a way to completely remove all formatting without deleting the values in the...

Hi everyone, As you can see by the table below I have the names, averages and then the rank. I use the rank formula so that I can have numbers depending on average. Rank Name Averages 7 Pat 0.00 6 Dan 2.00 7 Steve 0.00 3 Donald 5.00 7 Jim 0.00 7 Shelley...

I have the following various length text string: Hello World 123 abc; Love Excel 365 I would like to substitute the ";" plus one space with a hard space so that I get my results to show in two separate lines like this: Hello World 123 abc Love Excel 365 Can someone assist with the formula...

Good Day, Here is a challenge for the masters of excel (EXCELITES). I have a workbook with multiple sheets, all are formatted the same way and require the said information (SEE BELOW). <tbody> A B C D E F G I 2 NAME JOHN BROWN OFFENCE LARCENY 3 DOB 27-3-72 4 OCCUPATION...

So daily I pull out a pretty large amount of rows with data for our weekly KPI reviews. The rows can be as long as 20k. What would be the most efficiant way of storing this amount of data? I was thinking of PowerPivot tables, but having problem with IT section to get PowerPivot in to Excel...

HEY EVERYONE WOULD LOVE YOUR HELP CTRL+SHIFT+ARROW DOWN STOP WORKING, any suggestions why is that? i forgot to mention that is the only shortcuts that stopped working...

hey everyone i have a X and Y , and i am trying to move the axis from right to left http://www.andypope.info/tips/tip006.htm would love your help

i have two columns. If a word or words in the world list is found in the text string in column A, I want to put found in the adjacent cell or not found. I want to be able to drag cursor down column C. <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B...

Hello, My name is James Pace and I am a MBA student at Brigham Young University. I am doing a marketing project on Excel and would like to interview people, through video chat, to obtain Excel consumer insights from the Excel love group. If you love Excel and would be willing to share your...