Posts by Kyle Johnson2

frozenbadger72 said:before I wiped my Windows install, I had this one text doc I could edit just fine. Now? After the reinstall, the file went from a plain .txt to an .mdi

What program were you using to make and edit that doc? An *.MDI extension is a file meant to be opened with "Microsoft Office Document Imaging". Check out the link and see what's up.

Amy Hughes50 said:whenever I paste images into Word, they just stack in the top left corner... then they drift down diagonally

Take a look at the image formatting settings and try tweaking them

Guys, chill out. It’s his first post, you're gonna overwhelm him 😉

Brian Sullivan2 said:can someone please solve these 3 problems for me? and maybe tell me exactly what to click step-by-step. thanks
http://www.highschool-example.edu/s...aniela_usmiani🙂🙂🙂just go to Computer Science Grade 10 and there are the three tasks right there.

Tom, check this link (or just pick up a textbook) and get to work

- Beginner's Guide to Microsoft Excel with visual examples

Anthony Stewart2 said:Basically, the folder holding those emails was on a different partition, not the system drive.

There isn't really another way. If those *.dbx files are actually intact, find a machine with some old Outlook Express 6 and Outlook sitting around.
First, pull your backed-up messages into OE6, then move them from OE6 over to Outlook, and finally export everything to a *.pst file.
Other than that, I'm drawing a blank.

Anthony Stewart2 said:Still stuck. Any other ideas? 🙂

If you can get onto PC "A" where the OE is and all those emails live, just fire up Outlook and import everything from Outlook Express 6 into it. Once that's done, hit Export in Outlook to create a *.pst file. Throw that *.pst file onto a USB drive.

Then jump over to PC "B" running Windows 7, open Outlook, and import the data from that *.pst file you saved (like on your USB).

Walter Jackson48 said:Try dropping this formula into column B. It works even if cell A1 is zero:

@Walter Jackson48/">@@Walter Jackson48, yeah, your formula is solid.
Just to break it down for everyone else following this thread: 😉



basically, the first formula gives you the Nth count for every single value, while the second one just grabs the very first value in the sequence.

Later, Walter Jackson48 😉

cosmicbison19 said:how do I use COUNT to only count cells in the second column where there's a 1 entered?

Just pop this formula into cell B1 and drag it down
Code:

Anthony Stewart2 said:Can I import an Outlook Express 6 mail folder into Microsoft Office Outlook? My current setup is running Outlook on Windows 7, but the actual mail folder from Outlook Express 6 is sitting on a machine running Windows XP.

You've got two ways to handle this:

- LINK1
- LINK2

crimsonraven6 said:is there any way to write text over images?
if so, how? because every time I try, the text just sits under the picture instead of on top of it.

You're being vague as hell, and which Excel are we even talking about? Just drop a sample file on the forum. What kind of images are we dealing with, where do you want them, and what's the actual goal here?

What kind of text are we talking about going over the image (maybe some WordArt text)? Is this text coming from a formula or just plain old text in a cell? Does it have to be in a cell, or could it be a transparent TextBox sitting on top of the image? How many images are in the Worksheet? etc., etc... Too many questions, and you only gave me two sentences.

btw: check these out

- How can I put an image behind excel cell
- Add a background image in Excel 2007
- How to Make Text Over Images With Microsoft Excel

Maybe you could just stick the image in a cell comment? (Ever thought of that?)

- Inserting images into Excel cell comments

[EDIT]: Here's a tutorial if this is what you're actually aiming for:

- how to set an image behind text and formulas in Excel

darkwalker2 said:Thanks so much! I meant I wanted to justify the text, yeah, just phrased it a bit clumsy. But... still not working right because it leaves this massive gap between my two paragraphs. My line spacing is set to 1.5, which it is, but as soon as I try to start a new paragraph by hitting ENTER, the gap jumps way past 1.5.

Dropped a link in my last post for fixing that justification issue. Here’s the link for tweaking the spacing when you hit ENTER.

Don't use Shift + enter to jump to a new paragraph—that’s just a line break, so it stays part of the same paragraph.
Turn on your paragraph marks (the little upside-down P) so you can actually see where your paragraphs end.
Hit Ctrl+5 for 1.5 spacing.
Check which version of Word you're running and set the style to "No spacing" if you're stuck using Word 2007.

Justin Torres77 said:How do I increase or decrease numbers by a specific percentage?

Honestly, idk why you didn't just upload an example file since you already posted a screenshot anyway.

btw: Just use this formula
Code:

Depending on if your percentage is positive or negative, this will either bump up or drop down the sum of those first four columns.
Just drag it down to the bottom. Here's the attachment

Hannah Taylor14 said:2. the issue - double numbering
So, say you want the Header to show page X of Y for the whole document,
but then have the Footer show the page number within just that specific section/total pages in that section.

Here's a tutorial for ya

- how to handle dual page numbering in Word sections vs. the whole document

The tutorial does it backwards.
It puts the per-section count in the Header and the full document count in the Footer.

darkwalker2 said:How do you right-align text without having those weird gaps between words in a single line?

It’s kinda weird that this is happening with the right alignment. Usually, you only see stuff like this when you grab some text off a website, dump it into Word, and then try to align it. It’s all about balance..

(if it’s a secret) Just wipe everything else from the doc except the specific part giving you grief, then upload it somewhere like Dropbox or Google Drive: Here.

Amy Sanchez70 said:Is there any way—seriously, is it even possible—to split one massive Microsoft Word Document into several different files? Please, please don't tell me I have to manually hack through all 30 pages one by one (highlighting, opening a new doc, pasting, saving, etc.)

Look, I don't really care why copy-pasting into a new file is such a headache for you
but if it’s actually making your life miserable, check out these links

- split pages in document into separate documents
- How to Split a Word Document
- using a Macro

Jesse Wilson17 said:google - > pdf to doc online free

I didn't quite catch if she actually wants to convert PDF to DOC, but hey, maybe that'll "do the trick" for her.😉

Hannah Taylor14 said:Got any suggestions?
............... Or maybe this could be done through some kind of macro? (Haven't messed with those yet, but hey, never too late to learn something new)..

If we can't find a workaround, you're stuck doing it manually. Check out THIS link and the VBA macro there. It’s about pulling images from files, which is basically the same thing since we're just treating these PDFs like images anyway. I haven't personally tested it, so give it a shot.

Also, check out this link for a VBA macro that inserts a PDF into Word
Code:

though that other tutorial is better for me since it uses an Excel list

Hannah Taylor14 said:How do I shove a PDF into Word (2007) so it actually shows every single page?

You should probably just split that main PDF into smaller chunks using some software, then go ahead and insert each part as an Object into Word.
- Check out this file. So, I took this PDF and split it into two separate files since it had two pages. Then I just went ahead and inserted each one as an object into Word. One page per file, simple enough.

You’re gonna need some specific software for that.

Hannah Taylor14 said:2. issue - double numbering
If there's already a link handling... the other part

Check this out here http://support.microsoft.com/kb/212313

Gerald Young25 said:Yeah, that works, but then I'm stuck manually checking if hours are >10 or div>

You're right, but in this setup, the text part is basically just two digits for days, two for hours, and two for minutes.
Code:

And the formula looks like this:
Code:

which gives you the final result 50:15:00
Go check out how the MID function actually behaves.

Gerald Young25 said:One more thing.

Don't get mad, but throw an attachment with some fake dummy data (for downloading from the source) so we can actually see what's going on here without me losing my mind.😉

[edit]
Here's an example of how to sum hours across two sheets onto a third one. LINK
The formula would be =SUM(Sheet1:Sheet2!A1:A6)

Arthur Ramirez20 said:wondering if it's doable to build a soccer league in Excel—like, with scores and a live standings table? If so, how'd you even go about it...

check out this example

Gerald Young25 said:Hey John, what formula should I use to convert this kind of time format:
2d 12h 52min

Give the MID function a shot.
Code:

That'll spit out 60: 15 in column B.
You've gotta mess around with the MID function and its arguments to get it right.😉