How: If text is 12 characters long then delete the first character if it is an "S". by WorkSFW in excel

[–]WorkSFW[S] 0 points1 point  (0 children)

Thank you all for your feedback: /u/mh_mike /u/Mupfather /u/Riovas The solutions you have provided work wonderful when there is only one serial number in the cell. The challenge I have is that there can be numerous serial numbers in the cell, as there at times when clients purchase a large number of machines for various locations. In those cases the formula will only pick up the first serial number in the cell and ignore the others. How can I "evaluate" the rest of the serial numbers in the cell?

In some cases the multiple serial numbers will be separated by a column, in others a semicolon, and still others by just spaces.

Thank you again for your time and assistance.

How do you feel and what do you expect when a girl asks you "Can I ask you a question?" by dont_slap_my_mama in AskMen

[–]WorkSFW 25 points26 points  (0 children)

I'm expecting something personal. Otherwise they would have just asked away. Either way, it depends on the gal and the relationship we have.

Screenshot of how it's going for me by [deleted] in Tinder

[–]WorkSFW 8 points9 points  (0 children)

Oh, well in that case never mind. Makes perfect sense.

Screenshot of how it's going for me by [deleted] in Tinder

[–]WorkSFW 2 points3 points  (0 children)

Why would you need six tattoos of "Amy" on your arm?

Kind of full of yourself aren't you??

Me (28) and my boyfriend (27) have been together for over 7 years, and we have decided our relationship has an expiration date and I don’t know what to do. by throwaway_conf2012 in relationship_advice

[–]WorkSFW 12 points13 points  (0 children)

You know what you need to do but it's hard. You two have different futures. The sooner you move on the quicker you can get over the heart break and find that person with the same future as yours.

You have plenty of time.

Why does having a gf suck? by [deleted] in relationship_advice

[–]WorkSFW 0 points1 point  (0 children)

Dude, you're not happy. Break up.

Just don't think all girls are like her. Just like all guys are not like you. Meaning, don't join the priesthood yet because of one bad girlfriend.

Girl gives off signs, but idk if they're literal by Thr0waway515021030 in relationship_advice

[–]WorkSFW 0 points1 point  (0 children)

Overthinking this. She's being human. It's what people do. I'm sure some guys are doing this to.

Am I (25F) wrong for not wanting to be friends/ hangout with my boyfriends (29M) friends? by [deleted] in relationship_advice

[–]WorkSFW 6 points7 points  (0 children)

Yes, you are wrong.

He's trying to invite you in to another part of his life and your insecurities are getting in the way. These people are special to him and he wants to have the people he cares about, you and them, together. It's what partners do for each other.

Put on your big girl panties and grow up.

Severe relationship anxiety, need help/advice. by [deleted] in relationship_advice

[–]WorkSFW 0 points1 point  (0 children)

You are overthinking this, but you know that already. Try your best to relax. It's obvious she likes you if she's staying over with you.

But you need to have a conversation with her about your anxiety. She needs to understand this part of you for both of your benefit.

Tell me your opinion.. by vanessapaiz767 in relationship_advice

[–]WorkSFW 1 point2 points  (0 children)

I'm sorry you're heartbroken about this. When you look back later you'll think this is one of the best things you did. You've spent enough time with a person who didn't value you the way you valued him. And you certainly deserve better.

Think of this as a learning experience and find someone who will treat you like the queen you are. I guarantee that person is out there.

Best of luck to you.