Posts by Kenneth Carter27

Here’s my deal:

I’m 25 and I just landed a gig on a cruise ship here in the States. Passed the Skype interview, and the company is covering my flight and hotel to get to the ship. The catch? I gotta front the cash for my visa ($383), my passport renewal—not sure if the fees stayed the same, honestly ($150), and my medical exam ($433).

The thing is, I'm unemployed, totally broke, and don't have anything to pawn. I’d ask friends or family, but right now, nobody's got it to spare.

If anyone knows someone who could lend me some cash—we can make it official with a contract and a set interest rate.

I’d pay it back literally two weeks after I head out, since they pay us every two weeks on the ship.
I'm even down to have someone pay the bills directly instead of giving me the cash, just so everyone knows I'm not trying to scam anyone...

Alright, here's the deal:

I've got this spreadsheet where I've listed out cities along with their zip codes...

For example:

90210 Beverly Hills
10001 New York City, NY 10001
....

Now, I need to split them up—put all those zip codes into one column (column 1) and the city names into the next one (column 2). There are about 2,000 entries total.

What's the easiest way to pull this off?

I tried using the "Text to Columns" feature in Excel, but it's acting up because some cities have multiple names or extra spaces—so it keeps splitting everything into way too many columns.

Michael Jackson10 said:It probably says "proficient in Microsoft Office" on their Resume—as if that actually means anything lol. ☕

The first problem—just go for the direct solution, no macros or scripts needed, just straight raw power:

Just add a "Gender" column—keep it simple—so every row shows either "Male" or "Female."

Just pop this formula into the first cell: =IF(LEFT(A1,4)="Mr","Male","Female")
Just swap out that cell A1 in the formula—use the actual cell address where the data lives instead!

How to drag a formula down an entire column?

The fix only works if the data is totally unified—like, everyone needs to be labeled consistently as "Mr." or "Ms." If you have one lady listed as "Mrs." and someone else as just "Ms.", the formula is going to trip up—so you’ve gotta either tweak the logic or normalize the whole dataset first...

Any recommendations?
Look, if you're totally lost—just make a backup copy of the file and mess around with that instead!

Edit:
The syntax is from OpenOffice—I'm honestly not sure if I should be using a comma or a semicolon...

Thanks a ton—it’s just not showing up on my Resume. 🙂

So, one of the guys responsible for all the data entry from Excel just called out sick—and apparently, that's somehow my problem now? I'm strictly on web design duty... what even is this??

🙂

So, it’s my first day on the job and I'm already hitting some walls:

I've got this spreadsheet where I need to figure out someone's gender based on their title—like Mrs. or Ms.—how do I tackle that? I'm looking at about 2,000 entries here.

Also, how can I bulk-delete the "US-" prefix from all the addresses in my table?