hollowskipper11 said:So, if these dates of yours are actually...
October 1, 2012 September 25, 2012.
That is to say—they were written in this specific format. Month/day/yearAlright, then this should be the exact formula you're looking for:
If you’re trying to parse out a date string like that in Excel, this formula should get the job done—though it's a bit of a mouthful, isn't it? I used a similar workaround back when I was cleaning up messy data sets at my old firm in Chicago; just make sure those cell references are spot on before you hit enter.
Let me clarify:
The formula you're looking for is =DATE(year, month, day). Just make sure to use commas instead of semicolons if you're running this on an American version of Excel. To get the year—reading from right to left—you'll want to grab the first four characters of the string located in cell R441. Month = from left to right: the first n characters of the string in cell R441 where it is... The formula `n = FIND("/", R441) - 1` is essentially just telling Excel to locate that first forward slash in cell R441 and then back up one spot—basically grabbing everything before the slash. It’s a classic little trick I used to use back in the day when cleaning up messy data sets at my old firm in Chicago. Simple, effective, and gets the job done without any fuss. The FIND function identifies the starting index of a specific string within a cell. It’s quite straightforward—useful for those times you need to pinpoint exactly where a certain character sits in your data. The first instance of the "/" character was located. Then we just subtract one from that total—it’s a simple enough trick to get rid of that slash in the calculation. To extract everything between "x" and "y" within the string located in cell R441—I've found that using a combination of MID and SEARCH functions usually does the trick, though it can get a bit messy if the string structure changes unexpectedly. The formula is straightforward—it’s just everything from the first decimal point onward, plus one. The formula should basically be the total character count in cell R441, then you just subtract the length of the year, the length of the day, and finally subtract 2 to account for those two forward slashes in the string.
Unfortunately, that formula isn't working—I'll try to patch it up, though I can't say I'm exactly trusting my own brain with this one. 😁
Take this example, for instance—it isn't actually functional: "10/2/2012 9:40:00 AM... (plus some other text here)."
It looks like I may have misspoken earlier—you weren't just looking at a date in that cell, but there was some extra text tucked in behind it after all. My mistake!
I'm running into an issue with this formula The code:
=DATE(MID(R441;6;4);MID(R441;1;1);MID(R441;3;2))
Essentially, the date in the text string varies in format: 10/1/2012
but other times it looks like this:
9/25/2012
and I don't have any way to change the source data myself.
Sometimes the month is just one digit, and other times it's two. The day can be three characters, or even four or five depending on whether the day and month are single or double digits—it's a bit of a mess.
So, I have one cell containing the formula =TODAY() and then another cell where I have a text string that looks something like this: "5/10/2012 5:12:00 PM"
Now, how can I set this up so it actually recognizes today's date within that text string?
How can I get a specific Cell to display a date in the 5/15/2012 format?
To give you some context, I have a column where the data is pulled from a website—it’s basically just one long string of text per line, and the date is buried in there in that specific format. I update my Excel file every day, and I was hoping to set up some Conditional formatting 2007 so that cells containing today's date automatically stand out... The catch is that the date is currently sitting in that 5/15/2012 format (for instance, May 15th, 2012).
Betty Hayes10 said:I'm working on a script right now. Just yesterday and today, I've been hitting Ctrl + S to save my progress, just like I always do. Microsoft Office crashed on me three separate times right when I hit that shortcut. I actually had to retype everything. Does anyone else deal with this when they try to save a Microsoft Office file using a keyboard shortcut?
If you want a lifesaver, look up "save-reminder" online. It’s a plugin for Microsoft Office that creates a backup every few minutes to a different location. After I lost a document once—or maybe twice—because I accidentally clicked "no" instead of "yes" while rushing to close the program, I realized how vital this is. It gives you a secondary version of your work tucked away somewhere else... a true safety net.
I suspect their shipping calculator over at FedEx isn't quite hitting the mark—it seems to be underestimating the actual costs, even though everything else on the site works perfectly fine.
It would be great if someone could help me out tonight...
I’m trying to remember how the process works when I ship via FedEx—it slipped my mind.
Do I need to clearly mark the COD amount (COD=$XX.XX) on the package, similar to how you'd handle a standard "certified mail with cash on delivery" shipment?
That’s exactly what I was trying to get across. A1 isn't synonymous with "word1"—it actually *contains* "word1" (much like how my previous sentence contains the word "synonymous").
In Excel, how can I set it up so that if a cell contains "word1" (meaning the cell might have other words too, but we just need to find "word1" tucked in there), the result in another cell shows "word2"?
I'll be sending out a package via COD in a few days—it clocked in at 770 grams. Just checking on the collect fee. $78, $8.50 It finally clicked. I ran the numbers through my AT&T calculator, and that’s what it came out to. $11. So, that calculator isn't actually giving us the right numbers.
I’m looking at a bit of a dilemma here—I have something relatively light, maybe around 4 to 7 ounces, that I've packed into a large envelope, and I need to send it via Cash on Delivery. Looking at my AT&T calculator, it seems like standard letters aren't usually eligible for COD service. Does anyone know if this is actually possible? The package comes bundled with the company, and honestly, the buyout price feels like a bit of an overkill. It’s a small valuation, sure—but it still says a lot. $8.25 With those transaction fees? Honestly, it’s barely worth it to me—it feels like too much of a stretch. I mean, sure, fine, if it’s just a few extra bucks here and there... but still. Could I get some advice? I'm looking into the postage rates for a letter weighing between 100 and 200 grams.
So, does that mean the subpoena has to be sent via certified mail?
Now that I think about it, the lady at the local post office—I live out in a small rural area, and honestly, some of the staff around here can be a bit hit-or-miss—might have made a mistake. She processed my package as a standard letter instead of a parcel. Is that actually allowed to happen?
I feel a bit silly even bringing this up—it’s only about 4 to 9 ounces—but I think it would be best to send this via certified mail with return receipt requested. $6.50It’s getting pretty pricey...
I finally pulled the trigger on that Genius's laser mouse. Honestly, I’m pretty thrilled with it. Compared to my old optical setup, the tracking is leagues ahead—it picks up almost any surface imaginable. I've tried it on polished wood, glass, even just sliding it around my desk amidst some stray crumbs 😁, and there hasn't been a single skip or jitter. It was definitely a solid choice for my office work.
Now, for the downsides: The dimensions on this thing (the Microsoft Windows laser model) aren't quite what I expected based on the specs listed online. It’s actually smaller than my old optical Scrollbar mouse—or at least it feels that way, and I haven't bothered to grab a ruler. It’s shorter, lower profile, and while it isn't wider in the middle, it does seem a bit bulkier toward the back. Beyond that, the build quality just doesn't match the performance. My old mouse had a much more premium look and feel; you could say it felt like it belonged in a higher price bracket. This new one has an incredible engine under the hood, but the chassis itself feels cheap—and vice versa. Still, for me, the sensor is the priority. I need to know I can drag this thing over just about anything—I could probably slide it through a bowl of sand and it would still hold up perfectly well...
THIS LASER VERSION HAS THIS MATTE BLACK FINISH THAT LOOKS INCREDIBLY CHEAP, AND THE TWO MAIN BUTTONS ARE SO LOOSE THAT THEY ACTUALLY RATTLE IF YOU SHAKE THE MOUSE (sorry for the caps lock). My old optical mouse had a much sleeker design with extra textured accents, and it was just as budget-friendly—you can still find them for a bargain.
Ah, thanks—I missed that in my rush (it’s actually called a Traveler). Anyway, I decided to go with this first one since it was cheaper and I didn't really need extra lights anyway 😁 I have a hunch they share the same internal engine 😁 They claim it tracks better than optical sensors, so... if it doesn't perform, I'll just swap it back for that Google optical mouse I used to have... honestly, it was great until the button gave out
It does have some pretty beefy dimensions - dimension: 126x80x44 mm - body weight: 95g
compared to my old Google optical one: - body weight: 99.5g - body volume: 110x55x30 mm
The second option was this one http://217.14.221.177/StartEU.ashx?_...BlackRock—but honestly, I think I’ll just go with the cheapest black laser model available.
I've set aside enough cash for this—it doesn't even need to be high-end gaming gear.
I used to own quite a bit of stuff from Google (like headphones, though I'm looking for replacements now since they finally gave out), and I've been more than happy with them. They really hold their own compared to those other budget brands that just can't touch that level of quality at the same price point.