Posts by Walter Jackson48

"You really should have just uploaded the file for us to download so we could actually see what you've been working on and how much effort you put in." Kyle Johnson2 has typed out this exact sentiment—and dozens of variations of it—a million times already. But hey, let's all stop and listen to him, shall we? For the good of the group, obviously.

Don't just keep it to yourself.
Every single solution needs to be posted right here on the forum, because who knows? Someone else might run into the exact same wall you did later on.
That’s just how we all handle things around here. Honestly, if we don't share, there's really no point to having a forum at all.
Best,

Robert Sullivan5 said:I'm trying to figure out how to insert a signature line directly into a document in Word 2003 so I can print it out. It’s perfectly obvious in Word 2007, but for some reason, I just can't find the setting in Word 2003.

Thanks!

Take a look at this:
http://www.elitesecurity.org/t390556-0

silvergull10 said:How do I change lowercase letters to uppercase in Excel?

Why on earth aren't you just using Replace:
1. To switch Street to Street,
2. Or to tack Street onto the front of a city, just swap the word city
with City Street and let the software rip through the whole document for you.

The solution is so incredibly simple that, frankly, I’m starting to worry I didn't even understand what was being asked here.

electricmarlin18 said:.... so, look, I've got one column with a start date and another one with an end date, and I'm trying to figure out how to calculate the total duration in years, months, and days.

Alright, here's the deal. In cell C1, just type Years, then in D1 put Months, and in E1 write Days.

Now, assuming you have your starting date in A2 and your end date sitting in B2, here is what you do:
In C2, plug in this formula: =DATEDIF(A2;B2;"y"),
then in D2, use this one: =DATEDIF(A2;B2;"ym") and
finally, in E2, drop in this: =DATEDIF(A2;B2;"md").

The rest? You can figure that out yourself.

Sure, that’s one way to handle it, I suppose. But honestly, if you’re already going through the trouble of opening every single document just to manually color the text, then why stop there? Since the style is identical throughout the entire file anyway, just hit Ctrl+A to select everything and on the selected text, simply wipe the slate clean and change ALL the font characteristics at once. It’s much more efficient.
Of course, everyone has their own little "special" way of doing things, which is fine, I guess.

It's not "....content in columns A and B," it's actually in A and Error.

Maybe try something like this:
Just pop this formula into cell B1: =F1&" "&RIGHT(A1,3)

The way it works is pretty straightforward: it grabs whatever text you have sitting in F1, tacks on a space, and then pulls the last three characters from A1, dumping the whole mess into B1.
So, if you’ve already got your data filled out in columns A and F, just grab that formula in B1 and drag it down through all your rows. It’s simple enough, provided the data is actually there.

briskscout4 said:I could really use some guidance on setting a sales price...

Look, you aren't actually going to learn anything if we just hand you the answer on a silver platter. What you really need to master first is the logic behind pricing algorithms, and once you grasp that, turning it into a formula is easy. If I just give you the math, you'll just scribble it down, and then the second a professor asks you how you actually arrived at that number, you're going to be staring back blankly because you don't understand the "why" behind the "how."

I genuinely want to help you out, but I also want you to actually walk away with some knowledge here.
Best regards.

briskscout4 said:Did I actually get the "tax-inclusive price" right? Look, I’m sorry, I’m still a total newbie at all this stuff 😢.

The way you have it here is just the tax amount itself, whereas the total price including tax should be the base cost added to that tax value (15.5 + 3.1).

Take a look at this:
http://office.microsoft.com/en-us/...001136621.aspx

I'm positive this will do the trick.

Maybe this will clear things up for you:

Suppose you drop this formula into cell C1: =SUMIF(A1:A5,"X",B1:B5)
Then, if you put this one in C2: =SUMIF(A1:A5,"Y",B1:B5)
And finally, in C3, you write: =SUMIF(A1:A5,"Z",B1:B5)

Actually, look—you don't even have to be that tedious. You can just use formulas that target the entire columns A and B. So, in those examples I just gave,
instead of limiting yourself to A1:A5, you could just use A:A, and instead of B1:B5, you’d just plug in
B:B. That way, when you inevitably add more data later down the line in columns A and B, column C will automatically pick up and sum those corresponding values from column B without you having to go back and fix everything manually. It saves a massive headache.

Douglas Miller60 said:how do I get all this text into just the left Column

If I’m following you correctly—and I usually am, despite how much people ramble—you’ve got a page set up with two columns, but you want everything shoved into the left one. If the Column tool is being stubborn and won't cooperate, and since you don't have a massive amount of content here, I've got a bit of a workaround for you. It's a little messy, but it works if you're desperate:
Use the Column tool to turn the whole thing back into a single column first. Then, just Cut the text. Once that's done, create a Text Box on the same page and position it specifically over the left half of the sheet. Paste your cut text right in there. Highlight the whole block and hit Ctrl+J to justify it so the edges look clean on both sides. Finally, just "paint" the Text Box fill white so it blends in and looks like part of the page.

If you’re looking to move a data table into a fresh, empty space, just highlight the entire range of data, hit Copy, head over to your target spot, and Paste.
Now, if you already have an empty table set up and you just want to dump the raw data into it without messing up the existing structure, don't select the whole table. Instead, just highlight all the individual cells in the source area, hit Copy, then click into that top-left cell of your destination table and Paste.

As for adding rows—because sometimes things never go quite where you planned—just right-click on the row sitting right above where you want the new one to appear, and select Insert, then Insert Row Above. You can do the exact same thing for inserting one below.

In cell D3, you'll want to drop this formula in: =IF($H$3<>"";$H$3;"") then just drag it down to D13 and beyond.
Basically, what she's getting at is that if you type something into cell H3, it’s going to show up in every single cell where you’ve pasted that formula. But, if H3 is sitting there empty? Well, then all those other cells stay blank too. Just a little bit of logic to keep things clean.

Maybe give the margins a little shakeup, or perhaps mess around with the font settings itself.

Gary Turner96 said:Is it actually possible to pull something like this off?

Would this work to get the job done:

=IF(105-G2>0;"Average";IF(120-G2>0;"Good";IF(135-G2>0;"Very Good";IF(150-G2>0;"Excellent";"With Caution"))))

Gary Turner96 said:Now I’ve got this massive question on my mind, and I really hope you guys can follow what I'm getting at here...

Look, maybe I’m misinterpreting the whole setup, but the transition from one range to the next is clearly defined by the formula sitting in cell "J". Honestly, I haven't the slightest clue what the result in cell "H" is actually supposed to be doing there. But, if it helps you out at all, you might want to just apply the same conditional logic to cell "H" that you used for "J".

Look, here’s a little trick I’ve used forever: try pasting your image directly into a Text Box. Basically, you just draw the box exactly where you want that photo to live, then paste the picture right inside it. Once that's done, right-click the image and hit Format Text Box. Go into the Layout settings, pick Square, then head over to Advanced and find Picture Position. You’ll want to check the box for "Move object with text" and also make sure you check "Lock anchor." Hit OK, OK, and you're set. Oh, and one more thing—make sure you change the Text Box fill color to white so the border doesn't show up and ruin everything. This works in the 2007 version, and honestly, it’s probably pretty much the same if you're using Word 2010.

Arthur Anderson49 said:Some silly little glitch with Microsoft Word. I need help.

Look, here is how I handle this mess: I go straight to my desktop, find the Word 2003 icon, and launch it from there first. Then, I hit that Open button at the top and navigate to the document I actually want to work on using the standard routine. Basically, I don't even touch the file directly through My Documents... It sounds a bit roundabout, I know, but I’ve tried it, and honestly, it works every single time.