I put together the below spreadsheet with randomly generated phone numbers as an example of what I need. It will be used for several things, but primarily for mail merges where both the 'Primary Phone #' with the dashes for easy reading and the 'Text to Email Address' columns will be pulled in.
I use the below formula to reference the 'Cell Carrier' in column C and return the correct sms suffix in column D:
=IF(B2="Verison","@vtet.com",IF(B2="AT&T","@txt.att.net",IF(B2="T-Mobile","@tmomail.net",IF(B2="Sprint","@messaging.sprintpcs.com",IF(B2="US Cellular","@email.uscc.net",IF(B2="Cricket","@sms.mycricket.com",IF(B2="MetoPCS","@mymetropcs.com",IF(B2="Ting","@tmomail.net",IF(B2="Consumer Cellular","@txt.att.net",IF(B2="Boost Mobile","@sms.myboostmobile.com"))))))))))
Then I use the below to remove dashes from the phone numbers in column A, to return the phone numbers with no dashes into column B:
=SUBSTITUTE(A2,"-","")
Then I concatenate columns B and D in to column E for the end result:
=CONCATENATE(B2,D2)
Is there anyway to do this with fewer columns, preferably in one after data entry for columns A and C?
https://preview.redd.it/jilsnobpdml41.png?width=1053&format=png&auto=webp&s=dc60023cedd570a7d840afb63a681e1ad811f2a3
Hello!
I'm offering my programming services to develop affordable solutions to common tasks such as:
- Google Drive and Google Sheets automation.
- Telegram, Discord, Reddit and Twitter bots.
- SMS and Email notifications using the Twilio and Sendgrid APIs.
- Web scraping using Websockets, BeautifulSoup, Requests and Selenium.
- Performing repetitive tasks/routines on a web browser using Selenium.
- Batch file processing, uploading and downloading.
- NoSQL, SQL, JSON, CSV, XLSX, HTML conversion.
All the solutions are coded in Python 3 in compliance with best practices and PEP 8.
The scripts are cross platform compatible, you can also program them to run automatically using crontab on a Linux VPS, Raspberry PI or GitHub Actions and on Windows.
Prices are affordable and payments can be made via PayPal.
Delivery time is often 1-2 business days depending on project difficulty.
Examples
-
Desktop GUI app that helps freelancers and employers using wxPython, SQLite and Requests.
-
Tkinter App that finds and saves free proxies using Tkinter, Requests and BeautifulSoup.
Data Analysis Services
I am also offering Data Analysis services, which cover the process of collecting your dataset and your requirements to cleaning, modeling, exploring and communicating the results.
You will receive a report in a PDF file which can contain graphs, plots and tables from the question you need answered.
It is preferred that your dataset is in CSV, XLS or XLSX format. SQL and NoSQL are also acceptable.
If needed I will sign your NDA at no additional cost.
Examples
- [Baby N
Do your worst!
For context I'm a Refuse Driver (Garbage man) & today I was on food waste. After I'd tipped I was checking the wagon for any defects when I spotted a lone pea balanced on the lifts.
I said "hey look, an escaPEA"
No one near me but it didn't half make me laugh for a good hour or so!
Edit: I can't believe how much this has blown up. Thank you everyone I've had a blast reading through the replies 😂
They’re on standbi
Pilot on me!!
Dad jokes are supposed to be jokes you can tell a kid and they will understand it and find it funny.
This sub is mostly just NSFW puns now.
If it needs a NSFW tag it's not a dad joke. There should just be a NSFW puns subreddit for that.
Edit* I'm not replying any longer and turning off notifications but to all those that say "no one cares", there sure are a lot of you arguing about it. Maybe I'm wrong but you people don't need to be rude about it. If you really don't care, don't comment.
What did 0 say to 8 ?
" Nice Belt "
So What did 3 say to 8 ?
" Hey, you two stop making out "
I won't be doing that today!
You take away their little brooms
This morning, my 4 year old daughter.
Daughter: I'm hungry
Me: nerves building, smile widening
Me: Hi hungry, I'm dad.
She had no idea what was going on but I finally did it.
Thank you all for listening.
There hasn't been a post all year!
It’s pronounced “Noel.”
After all his first name is No-vac
What, then, is Chinese rap?
Edit:
Notable mentions from the comments:
-
Spanish/Swedish/Swiss/Serbian hits
-
French/Finnish art
-
Country/Canadian rap
-
Chinese/Country/Canadian rock
-
Turkish/Tunisian/Taiwanese rap
There hasn't been a single post this year!
(Happy 2022 from New Zealand)
Bob
So that I could frequently say, "I am going to walk 5 miles now."
Edit: My most popular post on Reddit! 😀 Thank you for the awards.
Just to clarify, 12345678
Me grabbing a soda from my (what I thought was) half full 12pk...
Notices there's only 2;
Me: "Awe man... This is a damn bird box!" Her: "What the hell does that mean?!" Me: (Pulls both cans out & shows them to her) "It's only got Toucans."
I'm not ashamed to admit the look on her face was glorious.
I was just sitting there doing nothing.
“BOOM”?!
"That's what they're fighting about."
Because his Visa didn’t work.
Because the audience only responds in a low ha
A happy Uncle.....
"Beauty, because beauty is in the eye of the bee-holder!"
Hello!
I'm offering my programming services to develop affordable solutions to common tasks such as:
- Google Drive and Google Sheets automation.
- Telegram, Discord, Reddit and Twitter bots.
- SMS and Email notifications using the Twilio and Sendgrid APIs.
- Web scraping using Websockets, BeautifulSoup, Requests and Selenium.
- Performing repetitive tasks/routines on a web browser using Selenium.
- Batch file processing, uploading and downloading.
- NoSQL, SQL, JSON, CSV, XLSX, HTML conversion.
- Advanced subreddit moderation tools such as dynamic post schedulers, auto-updating widgets, keyword monitoring and AutoMod configuration.
All the solutions are coded in Python 3 in compliance with best practices and PEP 8.
The scripts are cross platform compatible, you can also schedule them to run automatically using crontab on a Linux VPS, Raspberry PI or GitHub Actions and on Windows using Task Scheduler.
Prices are affordable and payments can be made via PayPal.
Delivery time is often 1-2 business days depending on project difficulty.
Examples
-
Desktop GUI app that helps freelancers and employers using wxPython, SQLite and Requests.
-
Tkinter App that finds and saves free proxies using Tkinter, Requests and BeautifulSoup.
Data Analysis Services
I am also offering Data Analysis services, which cover the process of collecting your dataset and your requirements to cleaning, modeling, exploring and communicating the results.
You will receive a report in a PDF file which can contain graphs, plots and tables from the question you need answered.
It is preferred t
... keep reading on reddit ➡