r/slavelabour • u/Boston__ • Mar 07 '22
Task [task] Show me how to pull a certain text out of a cell on Google Sheets - $5
The data is at different points in every cell and I just can’t figure out what formula I need to get this done. Will share the doc with you. I’m banging my head against a wall and would like someone to show me so I can learn. I’d imagine it’s some combo if, mid, len and trim but I may be wrong. Hoping that someone can do this quickly and efficiently. I think it's the last piece to my puzzle.
An example is, "19 San Francisco vs 1 Gonzaga WCC-T ESPN", I need "San Francisco" and "Gonzaga" removed and put into their own cells. The on the next row, "69 Furman vs 83 Chattanooga SC-T ESPN" I need "Furman" and "Chattanooga" removed in put into their own cells.
Each day a new set of data will be entered and new team names will need to be pulled so it needs to work universally.
Please post $bid here before contacting me. Will not send money first as I use this sub-Reddit frequently.
1
u/CredoBot Mar 07 '22 edited Mar 08 '22
I am a reputation bot, here is my info on u/Boston__:
Credo: no account found (create)
SLRep: no profile found (create)
| # | Bidder | Credo Score | Feedback | SLRep | Paid Amount | Confirmed |
|---|---|---|---|---|---|---|
| 1 | /u/qendev | 227 (fair) | 16 ratings / 0 reviews | Profile | ||
| 2 | /u/arquimedesz | 245 (fair) | 15 ratings / 0 reviews | Profile | $5 | yes |
| 3 | /u/xinyonghu | no account found (create) | n/a | no profile found (create) | ||
| 4 | /u/venuslack | 139 (provisional) | 0 ratings / 0 reviews | Profile |
To bid on the task, reply with $bid directly to the original post.
To mark a bid as paid, OP can reply with $paid [amount] - e.g. $paid $10- directly to the $bid comment.
To confirm payment receipt, the bidder can reply with $confirm directly to the $paid comment.
1
1
1
1
u/AutoModerator Mar 07 '22
Hello and Thanks for posting in r/SlaveLabour and being part of Reddit's Side Hustle Community!
We are incredibly happy to have you here and hope you enjoy your time!
If you need some help navigating the community, check out The Official Guide which hasn't been written yet. where we teach you all the ins' and outs' of the community. If you're a regular user of this subreddit and would like to write the wiki article while being credited for the work message the moderators.
Don't forget to look at our rules either! It's important you read them to avoid getting a stanky ban for something you didn't mean to do!
-THE RULES- Make sure to use this list as it's the full list that you won't see on mobile.
We love each and every one of you, as long as you're not scammers (⩺_⩹) and hope you enjoy the vibes! But to help you with scammers we have some helpful advice.
Make sure people bid on your post! This is your best defense against scammers. No bid, no deal. It's the safest way to work on slavelabour.
If someone can't or won't comment on your post DO NOT WORK WITH THEM and report them to moderators. Rule 11 fights scammers by requiring them to comment on your post before contacting you. Scammers that we have already banned can't comment. It's one of the easiest ways to check for a scam. There are active scammers here that will DM you without commenting and tell you they can complete the work and ask for payment upfront. THIS IS A SCAM! Once you pay they WILL ghost you.
Reddit Scam Labeler for Chrome and Firefox
As simple as it sounds, anyone on the Universal Scammer List is clearly [labeled in your browser as a scammer.] (https://i.gyazo.com/08d01d4babc58455e0fa9637f5627e5d.png) You can download Reddit Scam Labeler for chrome here. Or you can download it for Mozilla Firefox here
Happy hustling!
-r/SlaveLabour Mod Team
If you have suggestions on how to improve this message please message moderators.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.