Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

So, here is the situation. I am quite lost when it comes to upgrading Microsoft Office. What I actually require is Publisher 2003, which, naturally, was never installed on this computer to begin with. Even the internet has proven entirely unhelpful... and my patience is wearing thin as I struggle to find a way forward. If someone could please assist me, I would be most grateful, otherwise, I might just lose my mind... Thanks. 😵

You might want to grab it right here

http://download.cnet.com/Microsoft-P...-10967173.html

I need some help calculating full combinations for sportsbook systems. Here’s the situation: I have a 7-game system set up in Excel, and the system consists of...
I have a 4-line system with 4/5 combinations. I need to pull the specific payout amount for every single combination (ticket) in that set.
I need a way to pull the winnings—but I want to do it without having to manually type out all five combinations.
I’d love to just knock this out with a single Excel formula—if one even exists. Any ideas? Thanks in advance.

Jesse Sanders6 said:I’m looking for some assistance regarding the calculation of full combinations within betting systems. Here’s the situation: I’ve set up a system in Excel involving 7 different games, and the specific combination looks like this...
I’m looking at a 4-line parlay system—basically a 4/5 setup. What I need is a way to calculate the specific payout for every single individual combination within that slip. I want to see the exact amount for each combo, not just some vague total.
I’m trying to figure out how to pull these specific wins, but I want to do it without having to manually type out all five separate combinations. It's just tedious.
I’m honestly hoping I can just knock this out with a single Excel formula and be done with it, but frankly, I have no idea if such a thing even exists. It feels like I'm spinning my wheels here. Any help would be greatly appreciated.

Look, it’s definitely doable, but you can't just wing it. You need to actually get some momentum going first. Just take those pairs and drop them into the cells to get a baseline. Once you've got that set up, either throw the whole document my way or at least send over a screenshot so we can see what we're actually dealing with. Trying to figure this out blindly like this is just pure guesswork, and frankly, it's a waste of everyone's time.

frozenheron7 said:It’s definitely doable—just get something started first. Throw those pairs into some cells and then either send over the file or at least a screenshot so we can actually see what you're working with. Right now, you're just guessing in the dark.

Here—this is a shot of a system using four sheets where the condition is set to 3/4.

frozenheron7 said:It’s definitely doable—just get a head start. Put those pairs into the cells and then either dump the file here or at least grab a screenshot so we can actually see what you're working with. Trying to solve this blindly is just guesswork.

The image shows those four 3/4 combinations, but I don't want to manually type them all out. I'm looking for a way to handle this using a specific function or command instead. Thanks for the help.

Hey there! I’ve been losing my mind over this for two days straight—poking around help files and scouring Google until my eyes hurt...
I can handle the easy part: building an Excel sheet where the first column lists every single day of 2015 in the format "Thu 1/1/2015"—all 365 of them, no problem there.
But here’s the headache: I have about 50 clients listed in a row. I need the table to automatically generate employee names based on a specific logic—basically, "For client Mate Trade, Pero Peric works on Thursdays," so I need Pero Peric's name to pop up for every Thursday throughout the entire year.

How on earth am I supposed to pull that off?!
If I had to rate my Excel skills, I’d say I’m at a solid 6/10—decent enough, I guess—but clearly not enough for this particular mess. Could anyone just give me a little hint to get me moving?

Grace White66 said:Hey there! I've been banging my head against the wall for two days now, scouring Help files and Google...
I want to build an Excel sheet where the first column lists every single day of 2015 in this format: "Thu 1/1/2015". I know how to handle those 365 entries.
Then, I have rows representing clients (about 50 of them). In the grid, I need specific employee names to automatically pop up based on a schedule—something like "Client Mate Trade works on Thursday with Pero Peric." Basically, I want Pero Peric's name to show up for every Thursday of the year.

How on earth do I pull this off?!
I’d rate my Excel skills at about a 6/10, but clearly, that isn't cutting it here. Could anyone just give me a little hint?

If you put the first date in cell A1, try adding this formula to cell A2:
Code:

Just swap out the text strings like 'MON' or 'TUE' with your actual employee names, then drag the formula down all the way to December 31st. ☕

Grace White66 said:How on earth is that even possible?!

She could just lean on some Excel functions like IF, AND, VLOOKUP, WEEKDAY. Just whip up a formula in cell B2 and drag it down and across

Code:

Jesse Sanders6 said:In this image, you can see those four 3/4 combinations, but I really don't want to type them out manually. I'd much rather solve this using one of the built-in functions or commands. Thanks for any help.

Sorry man, I'd love to lend a hand—but I’ve never stepped foot in a sports betting shop in my life, so these specific combinations mean absolutely nothing to me.
If anyone else here knows their stuff, great—but for me, you’re going to have to put together a step-by-step guide. 🙂
Basically, a "for dummies" version. 🙂

I might even be able to whip up some VBA code to handle exactly what you need (if we can't nail it down with a standard formula, though I suspect we should be able to), but I'm going to need some very detailed instructions first.

Jack Hayes said:Just pop this formula into cell A2 (assuming your first date starts in A1)...

Quick correction: I meant cell B2 if the first date is in A2... My bad, just a typo! 🤷

I need some help here. Every time I try to use justified alignment in Word, I end up with these massive double spaces between my words. How do I fix this?

Rebecca Cooper92 said:I need some help here. When I use justified alignment in Word, I keep getting these huge double spaces between my words. Any idea how to fix this?

So, here's the deal with justified alignment: it basically stretches the line from the left margin all the way to the right by forcing extra space between words. If you have a short line with a lot of room left over before the right margin, the software just shoves those extra gaps in there to make it fit, which can definitely look pretty messy. If you aren't a fan of that look, just highlight that specific paragraph—don't worry about the whole document—and switch it back to left alignment.

Kyle Johnson2 said:You could totally leverage some Microsoft Office functions like IF, AND, VLOOKUP, WEEKDAY to build out a formula in cell B2, then just drag it down and across...

Yeah, I definitely agree. It’s much smarter to maintain a dedicated "database" for your companies and employees—maybe even keep it on its own separate sheet. You'll really start seeing the payoff the very first time you need to update an employee's info...
👍

I need some help here.
I’m working on a mail merge in Word 2007. I have a database in Excel containing various amounts—basically numeric data with two decimal places. The issue is that when the data pulls into Word, it either strips the decimals entirely or, if the value isn't zero, it brings over way too many decimal places. How can I fix this formatting?

Hi everyone, I’m running into a bit of a headache while typing certain accented characters in Microsoft Word—specifically things like á, é, or ñ.

Basically, it happens quite frequently where I’ll hit one of those keys and Word just... ignores me. It won't register the keystroke at all. The only way I can get it to work is by typing a different letter first, deleting that extra character, and then trying again—at which point it behaves normally.

I did some digging and found a thread on another tech forum discussing this exact issue, though unfortunately, nobody provided a real solution:

http://forum.pcekspert.com/showthread.php?t=240384

I use several different computers around the house, all running genuine Windows 7 or Windows 8 along with Office 2010, and I have never encountered anything like this before. Honestly, it’s been such a persistent nuisance that it’s starting to drive me a little crazy! 🙂

Maybe try swapping out the keyboard. Borrow a working one from someone—just to rule out the hardware—or grab a different cable while you're at it.