CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online
log in · register
Home › Nicholas King › Posts

Posts by Nicholas King

1236 posts shown.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Noah Cooper40 said:well thanks, but I really should be doing this by recording a macro rather than actually writing out code...

I'm sorry, but why is that? 😕

When you "record a macro," that is exactly what happens—the software "writes the code" for you. In fact, this was created specifically by using the macro recorder. 🙂
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
cosmicbison19 said:Does anyone happen to know a formula for Google Sheets that does the following....

So, let's assume A1, B1, and C1 are your three target cells.

In whichever cell you want the result to show up, just plug this in:

=IF(ISTEXT(B1);A1+C1;A1+B1)
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Noah Cooper40 said:Hey everyone!

Can anyone tell me how to write a macro in Word 2007 that swaps out American accented characters (like those special marks used in other languages) for standard English ones (changing things like č, ž, š into c, z, s)?


Here is one for č, now go ahead and run it five times. I actually recorded this back in the 2003 version—I'm fairly certain it should still work fine in your setup.

I suppose you could strip away some of these parameters within the "With" block, but if you do that, you're essentially gambling on whatever settings were left over from your last find-and-replace operation—and honestly, I’d rather have too much precision than deal with the headache of unpredictable results. 🙂

Sub czs()
Selection.HomeKey Unit := wdStory
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "č"
.Replacement.Text = "c"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end Sub
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Walter Vaughn4 said:How am I supposed to sleep at night? Do I have to go into the settings? Like, where am I even supposed to find all this info so I can check it on one computer and then manually type it all into the other one?

Well, if I recall correctly—and I might be slightly off since I don't have my Outlook open right now—you should probably look under Tools -> Email Accounts (or maybe User Accounts, depending on the version). From there, you just pull up the properties, and you can jot down all those server configuration details.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Alexander Thompson83 said:I'm working on a survey for my senior thesis, and I want to include those little radio buttons—but I have no clue how to actually do it. Where are they even located? How do you insert them into Word??

Honestly, if I were you, I'd look into building the forms in a PDF instead—it might be a much cleaner option. Though, I suppose you weren't exactly being very descriptive about the issue you're facing. 🙂
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Dana Diaz8 said:Yes! Exactly! That's the one!!!!!! 🙏

Maybe just head over to John's place quickly and get a proper start on Excel. 🙂

I’m being dead serious here—if you don't, you're just going to waste your time and blow your nerves, and you'll never actually be certain if everything is functioning the way it's supposed to.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Walter Jackson48 said:This particular formula—if you follow standard rounding rules—actually bumps the fifth decimal place up by one for certain values.

If you’re looking to force that fifth decimal place to round up more aggressively, I guess using CEILING(A1, 0.00001) might do the trick—it would take something like 0.123454 and push it up to 0.12346, though, mind you, it would leave a number like 0.12345 exactly as it is.

Now, if you just want "standard" rounding, then I suppose you should probably just stick with ROUND.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Walter Vaughn4 said:I can receive emails just fine, but I can't send them at all
whereas on my other computer, everything works—sending and receiving without any issues.

Are you absolutely certain that the SMTP settings are identical on both machines? It seems to me—and I could be wrong here—that something hasn't been configured quite right on the one giving you trouble.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Dana Diaz8 said:it just isn't working 😕 or maybe I just don't know how to use it 🤷

Honestly, I can't even wrap my head around what this formula is actually supposed to accomplish.

Let me ask you one more time: if all you need is basic rounding—in which case, you should probably just be using the ROUND function.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Benjamin King2 said:Maybe try the old-school copy/paste approach—just head to the very end of your document, insert a section break, and then paste the next file right there...

The thing is, a section break alone isn't going to stop the text from getting reformatted.

The real issue here—and I say this quite dispassionately—is that people tend to build massive documents using "manual" formatting instead of actually being consistent with Styles. When you do that, it's almost inevitable that you run into these kinds of headaches.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Justin Torres77 said:"Your" formula—you know what I mean, b.i.t.c.h. 😁

What I was actually trying to get at is that I’m completely washing my hands of this whole formula—mostly because of that number four. 😁
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Drew Bennett68 said:I suppose I simply have to. If you find yourself staring at several disparate documents and realizing they all need to be merged into one single, cohesive file within Microsoft Office—well, I suppose there are a few ways to tackle it, though none of them feel particularly elegant. It’s a bit of a chore, really. One could, I guess, just copy and paste everything manually, but that is a recipe for disaster if you care about formatting—which, let's be honest, most people don't until it's too late. A more... deliberate approach would involve using the "Object" function found under the "Insert" tab. You basically tell the software to pull the contents of those other files directly into your master document. It’s somewhat efficient, provided your styles aren't a complete mess. Otherwise, you're just inviting a headache.

Why on earth would anyone even ask that? I mean—really—what is there to say? It’s such a broad, sweeping question that it almost feels like a trap, or perhaps just a symptom of the general lack of direction we see everywhere these days. I suppose I could attempt to unpack the layers of whatever specific situation you're implying, but without any context, it's all just guesswork on my part. Maybe you're looking for a deep philosophical breakdown, or maybe it's just a momentary lapse in thought—but honestly, without more detail, I'm just staring at a blank wall here. 😕

If you’re dealing with pagination issues, I suppose the simplest fix—and honestly, probably all you really need here—is to just manually set the starting page number in each individual document to whatever you want it to be. There are certainly more sophisticated, automated ways to handle that workflow, though I highly doubt you'd find them necessary given the circumstances.

You could potentially develop a separate set of content—then just manually copy and paste it wherever you feel necessary—though I suppose there is a more "intelligent" way to handle that process, if you really want to get technical about it. Not that you necessarily need to, of course.
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Dana Diaz8 said:0.123456789 => I use the TRUNC command to keep five decimals => 0.12345, but now I want that last digit to be a 6 instead of a 5, since it really ought to round up to the higher value 🙂)

Look, if you’re just looking for standard rounding, the ROUND function does exactly what you need—it's pretty straightforward. If you're aiming for some specific, non-standard logic, then you'll need to be a bit more descriptive about what you're actually trying to achieve. 🙂

Walter Jackson48 said:=IF(MOD(B166*100,100)=75,TRUNC(B166)+0.5,ROUNDUP(B166/0.5,5)*0.5)

What exactly is this formula supposed to be doing? 😕
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
cipal;32380904 said:3. column summed using Nicholas King's formula =SUMPRODUCT((E3: E66)*(0+MOD(ROW(E3: E66)-4;7)=0))

But seriously—why the heck is there a -4 in there? 😕

And for the record, that isn't even "my" formula. 🙂
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
electricotter6 said:Why does Microsoft Word change my spelling—for example, if I type "middle"—to something else entirely just because I hit the spacebar?
And things like that.

Just turn off AutoCorrect—specifically, disable "Autoformat as you Type".
→ go to post
Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software ·
Henry Morales6 said:Hey there! I'm trying to figure out how to open Office documents created on a Mac using my PC—specifically things like .docx or .pptx files...

First off, what version of Office are you actually running on your PC? Honestly, it doesn't seem to me like this is some sort of weird Mac-to-PC compatibility issue—that’s unlikely—but rather just an issue with you having an outdated version on your computer.

If you happen to be stuck using Office 2003, you should probably just download and install this.
→ go to post
Best ways to convert PDF to Word and Excel? in Software ·
Sandra Foster15 said:Does anything like that even exist?

Quality-wise? Definitely not.
→ go to post
Best ways to convert PDF to Word and Excel? in Software ·
Sandra Foster15 said:Can anyone recommend a program that converts PDF files into Word or Excel?
Is it even possible to turn tables from a PDF into an Excel spreadsheet?

Well, there is Adobe Acrobat—though it isn't free. It actually performs quite a bit better than the older versions of Adobe Acrobat, but I suppose you shouldn't expect perfection given how messy PDF structures can be.

There is simply no way to extract the original Excel file with all its formulas intact. These conversion tools usually manage to recognize a table, but they mostly just see it as a disorganized cluster of numbers and letters.
→ go to post
Is this harassment? in Feedback & Suggestions ·
driftingbear20 said:My apologies if I’m being blunt—I wasn't entirely sure if there was a specific way to report insults or harassment on this platform.

If you look at the bottom left corner of the post frame, you'll see a little red triangle—clicking that should open up the reporting dialog. Just type in your reasoning for the report, and that's pretty much it.
→ go to post
Can someone explain how the banning process works? in Feedback & Suggestions ·
Alex Cook said:Since I’m someone who scrolls through the US daily but doesn't post all that often, I'll give you my two cents. And just so we're clear, I'm staying neutral on this one—kind of like Nicholas King, though I'm definitely not as brilliant as he is.image

Prika, your whole vibe is generally sharp, and yeah, sometimes you can be pretty toxic. Personally, I don't have a problem with that—if someone comes at me, I hit back just as hard. But look, the US is basically a gathering spot for people who are totally messed up, insecure, socially awkward, you name it. They come here looking for someone to comfort them, to stroke their egos and tell them they're amazing and that their fairy-tale lives are just around the corner... it's pathetic. And when you act like this, which doesn't even have to be malicious, you just mess with them even more. It makes them even more insecure and shut down, cursing the day they ever decided to come to this forum for advice.
You're just looking at it from your own perspective, and that's why you can't see where you're going wrong.

So now, the real question is: who exactly is this reply intended for? That is the core of the misunderstanding (setting aside this whole business about the partial ban). 😁
→ go to post