#IT STANDS FOR LENGTH as in. length of a text string. b/c it counts. the characters in a set string of text. but GRAHHH

[sundial-girl]

wtf

get out of my fucking spreadsheet you piece of shit left mirror sound bitch

[octania]

Congrats on 200!!! 💫 you really deserve it honestly! Is it okay if I get 22 with our buff boy Obi 👉🏽👈🏽👀 best believe his fingers prolly feel great

I was so damn amused with the song WAP- Cardi B (WAP stands for Wet ass pussy) that one ANON mentioned (Sol bless your thirsty mind 🙏 )  , I decided to do these Headcanons so they match the lyrics (lyrics are the bolded parts in the text). That song is so damn thirsty I just could not resist, and my brain just could not let Obi go when I heard it, imagining all the ways he would please that WAP…..So, I will do this request + this idea, making a sweet smut pie out of it. I do recommend listening to the song before reading, it is like a thirsty hymn, I swear 🤣 . Bon appetit.

PROMPT 22. : “Look at you, I’ve only started using my fingers and you’re already shaking.”

Word count: 1.7 k

Warnings: NSFW, smut, spanking, rough sex.

Short description: Obi is a freak in the bedroom.

_________________________________________________

I want you to park that big Mack truck right in this little garage – You will never forget the first time Obi had his way with you, first time you two had sex. What that man did to your little cunt prevented you from sitting normally for a few days. You were no virgin, but you felt like one when he entered you. Only seeing the size of his dick for the first time, made you swallow nervously. Above average was a poor description  of it, massive was even a weak word…giant was the closest. As his whole body was, big and strong, his dick was matching it perfectly. He even went in gently, slowly, really giving his best to let you get used to the size and your pussy to adjust its walls to it. But there was no helping the feeling of being stretched to the limit, being filed to the brim, being too small for the cock that was only half in and you were already feeling dizzy. He would kiss your face, whispering- “Shh baby, you are doing great.” –pushing a bit more, then answering on your whines while you sink your nails in his shoulders. “Fuck baby…good girl, spread that legs for me…daddy will take care of you.” – your body released more juices from the arousal on his words. He felt the fraction beginning to be smoother, taking the advantage of the moment, sticking it in to the end. You screamed his name, as it echoed the room. Intertwining his fingers with yours, he pushed your hands into the mattress, picking up the pace. He started slowly and tenderly, but the clutch of your slippery walls around his length made him lose it, making the push turn into a shove, smashing into you with no hesitation, fucking you into the mattress like his pretty little whore.

He bought a phone just for pictures of this wet-ass pussy- You hate being separated from him, and he despises it even more. Not being able to touch your warm flesh and feel the soft skin on his, knowing he is being your shield from everything all the time makes him furious. What makes him even more mad, is when he is not able bury his rock hard dick into you when he has the need, and he does not care much for porn. He wants his girl, the one that makes his wildest and most intimate fantasies come true. So, what is better than to document that lewd fantasies? There is a phone. A smart phone with high resolution camera, and photos and videos are the only things that are on it. From all the pictures of you in tight skirts, role play clothes like nurses or cat girl, his cum dripping from your face as you lick the tip of his dick to collect the last of it, his favorite , and most used for his jerking, is the video when he was fingering you in one of the bases bathrooms. The sight of you pressed on that cold bathroom tiles , with your ass placed on the sink, legs spread as his two fingers travel to your G spot, caressing the velvety walls, and his thump pressing your clit to make the stimulation even more intense, gets him to cum in minutes while he strokes his dick on it. The part that makes him almost always cum in an instant is when he hears and sees your response on his comment. -“Look at you, I’ve only started using my fingers and you’re already shaking.”, he said while spitting on your clit to make the circular motions of his thumb on it even smoother. The golden response he got was priceless “Stretch my pussy with the third finger, please daddy.”- the strings of his warm cum almost always  burst from his throbbing dick when that part of the video comes. 

I want you to touch that lil' dangly thing that swing in the back of my throat – Touch it? He would pass by it, sticking it right on your palate, shoving that thick dick right in your tight throat, enjoying how he fills the space with ease. As you try to breathe, the muscles would clutch around his meant that would prevent you from getting that sweet air. Looking in your watery eyes, feeding on the sight of your mouth full, he would whisper “Suck baby.”- stroking your hair. Something about this soft gestures mixed with perverse things he does to you, gets him into a fever pitch. You purse your lips, push your tongue along his length, and suck in your cheeks, creating pressure around that massive thing. Oh, and daddy Obi is satisfied. Tilting his head, he enjoys your efforts to be granted air, petting your cheek. Then he pulls out for a brief moment, to let you fill your lungs with oxygen, just so he can repeat the process again…and again…and again.

 I'm a freak bitch, handcuffs, leashes – What made you think he is not a freak when it comes to toys?  Man is surrounded by various gadgets because he is not blessed with fire as a power, so he needs to be handy with the equipment. And we all saw that he is more than handy….so you better believe that passion and experience follows him in to the bedroom. When he is done filling your mouth with his own equipment, he wants to make sure that you will be quiet and not wake up the whole base with your screams while he fucks you to the point you have no sound left in you. He would wrap a tie around your mouth, handcuff you to the bed, and spread your legs. Seeing you that helpless, he had a need to save you. And how do you save a thirsty beauty? You quiet down that thirst. First, he would make sure you are all soaked and ready, because it will be a long ride once he is inside. He would rub his fat cock on your folds, along your slit, pressing it on your clit, creating a fraction that is making you insane. Swallowed by anticipation, you trying to jerk your hips up, just to be smashed back down on the mattress, and forced to endure his slow teasing game. You meet your punishment soon, when a vibrating thing meets your nerve bud. You scream around the tie that is stuffed in your mouth, just to be shushed again with his words. “The more you move baby, the more I will enjoy playing with your pussy.”- Another pleasure explosion, spreading along your body from your clit. Somehow you managed to peek down to see what is going on. Obi was pressing a small vibrator on your clit, continuing to rub himself on your entrance. “I need to make you nice and wet for what is coming.”- he explains in a husky voice, pressing the toy harder on your over stimulated pearl.

You can't hurt my feelings, but I like pain – Obi would be damned before he would ever break your heart, or even make you sad to be fully honest. He would carry you like a drop of water on his palm, giving you the treatment that only a queen would have. And that you are, his beautiful queen. But…as his queen, you have to be good to your king. Your behavior sometimes crosses the limits. He is a busy man, and he needs to fulfill his obligations on time, after all, he is a captain, and as a head of the house there is no slacking. So, when you continue to bother him while he is working by jumping on his lap, asking him a thousand meaningless questions, taking his papers that he is currently reading, teasing him by bending down, pretending that you dropped something just so you would put that booty right up to his face and you know he would stare at it because he can’t not resist the sight…well, you will get what is coming to you. That night, when he enters your room and climes on the bed while you are already asleep, he would turn you so your belly is on the mattress, grabbing your panties, pulling the fabric as it breaks with ease, smacking you with his rough palm on your ass cheek, so you are not only awake, you are well aware of the things that are about to go down. “What did I tell you about not letting me work?”- before you could murmur the answer, another sharp slap on your tender skin, making you whine. You are going to cry about this when you know you deserved it? Obi does not think so. He pushes your head into the pillow, smacking you a couple of times on the both cheeks, fast. The whines now are silenced by the cushy pillow, but his words are loud and clear. “Quiet.”- ordered the captain as the next slap is on your pussy, softer but still sharp. When his hand meets your sensitive parts, you feel dizzy with the pain mixed with pleasure, and he can feel your reaction by your trembling, letting him know he is really teaching you a lesion.

I need a king cobra – You know what they say, be careful what you wish for because you might just get it. And now you have tasted the consequences. I mean, what did you expect, the man had a picture of Double power cobra on the Fire force calendar. That was a clear warning. His body is representing one cobra, and the other the part in his pants. Your fault you decided to ignore the warning signs, now you can’t sit for a weeks or talk normally because that  cobra destroyed and owned your holes, like a king should.

Bonus: Hinawa walked into the bathroom, seeing something on the floor. He leaned, picking the thing up with his pen he had in his pocket. A bright red thong hanging from the tip of the pen. He murmured - “There’s some hoes in this house.”   ( 😂 🤣 😂 🤣  You will get this is you listen to the song 😂 🤣 )

If you want to support my work, you can leave me a small tip on Ko-fi 💖 . It is highly appreciated. 🥺 😍

[serpent-jugheadjones]

Dog Days - Part 1

Part 1 | Part 2 | Part 3

Pairing: Jughead Jones x Doctor!Reader

Description: Riverdale is facing dark times. Jughead has to choose between two paths. Will Y/N affect his decision?

Warnings: Fred’s current situation in the season finale and alcohol. Spoiler alert if you haven’t watched season 2 trailers yet.

Word count: 3038

A/N: These trailers are killing me with anticipation. I know Archie was the one to take Fred to the hospital, but that doesn’t make sense to me, so I wrote as if he arrived in an ambulance. Had to make the reader sort of a genius since I wanted it to be legal and not to big of an age gap.

GSW stands for Gun Shot Wound, BPR for Beats Per Minute and Breaths Per Minute, BP for Blood Pressure, OR for Operating Room, Y/L/C/H for Your Length and Color Hair, Y/B/M/D for Your Birth Date and Month. My EMS report may be completely wrong for a real one so if you are a doctor feel free to correct me.

I know I was supposed to post a new part for the Partner Revealed, but I couldn’t help write this one. Hope you forgive me!

Five seconds is as much time as the doctors have to breath in and out to clear their minds before the EMT pulls out the gurney and behind it comes a ginger boy, with a red stained cast and varsity jacket. “Robbery gone wrong at Pop’s. Patient Fred Andrews, male, GSW to the abdomen, no exit wound, patient is unconscious, pulse 66 bpr, BP 140 over 80, respirations at 19 bpm. ETA 6 minutes after call, we have an 18 gauge IV and controlled bleeding.” In 30 seconds the paramedic gives them the report already taking the man to the closest trauma room available. “Is my dad gonna be ok?”, the boy asks desperately standing at the edge of the door where his father lays motionless. “We’ll do everything we can.”, Y/N answers him calmly. “Nurse. Take ...” She looks at the boy waiting for his name. “Archie.”, he replies. “Archie to the waiting room please.” She rushes in to check Fred’s wound. “I need an X-ray and two bags of O-. Page Dr. Stone and book OR 2.”, the ER doctor instructs Y/N.

Jughead, Betty and Veronica arrive at the hospital not too long after Fred is taken into surgery. They spot Archie in a chair at the reception, looking helpless and unbalanced. His expression softens at the sight of his friends running to hug him all at once. Jug’s arms around them all, staying like that for a short while before they rest. “What happened?”, Jughead asks tenderly, sitting down next to his friend. “We were at Pop’s. I was in the bathroom and heard noises, when I came out, there was this man, wearing this hood, with a gun at Pop Tate and then he pointed it at my dad and fired. Then he ... “, an incredibly distressed Archie answers. “Then he what?” His girlfriend looks hopeless. “He ran.”, he finishes his sentence distractedly. Jug reckons Arch could be keeping something from them by the way he spoke.

This is the worst possible time for Jughead to be worrying about his relationship with Betty. However, so much has happened in less than 24 hours that he barely had time to process it. They left the Jubilee in awe, ready to show how much they love each other. Instead, what could have been a perfect night was spent arguing over a family issue. It drove him mad how much of a hypocrite his girlfriend can be. He almost wanted to take back what he confessed to her earlier.

When Jug got the call from Archie, he was still wearing the source of the problem. Betty had to remind him that showing up at the hospital with a Serpents’ jacket right after his best friend’s dad had just been shot wasn’t a smart idea. He knew that. Nevertheless, he was being torn apart. That snake embroidery was always a reason for confrontations with his father. In spite of that, the second his fingers touched the cold material and he first slid it on, Jughead felt at peace, safe. Like he finally belonged and ultimately understood his dad.

His girlfriend, if he can still call her that, is accommodated next to an incredibly tense Veronica, not even looking at his direction. Right now there’s nothing he can do to fix that, and, quite honestly, he doesn’t know if it’s worth trying. What he can and wants to do is help his ‘brother’ in any and every way he can. “Arch. Can we talk privately?” He points at the empty hallway and the red-haired boy follows him. “What is it, Jug?”, he asks, still looking at the reception, just in case someone comes out with some information. “For a moment, it looked like you were about to say something, about the hood guy, and reconsidered.”, Jughead states. “Really?” Archie fails at sounding convincing, certainly because he’s too tired to properly pretend. “Part of what makes you so endearing is your utter lack of a poker face.”, Jughead tells him in a sensible way. Archie stares at him wonderingly. “You have to stop taking the weight of the world by yourself, pal. You are not alone, Archie.” He shows himself with both hands from top to bottom in a very dramatic way, then the waiting room full of his friends and their parents. Jug knows he’s not one to say, as he for months lived inside the school’s storage closet instead of asking for help. Though, after his father was wrongfully arrested, it was all of them together who made it right and he started to rethink his ways. There’s nothing he wants more than to make that happen for his friend.

Archie takes his time to answer. “What if this wasn’t just a random thief? I know Clifford wasn’t happy with my dad working at the Drive-In land. He did everything in his power to stop the construction. What if Mr. Blossom ACTUALLY did everything to terminate it?”, he blurts out without barely breathing between words, releasing some of his build up stress as he tells out loud the theory that’s been keeping his mind unsettled. “He was a powerful man, no denying that. Still, I doubt Cliff could be doing anything from the grave. Although, if you’re telling me it looked staged, then it’s paramount we find out who’s pulling the strings.” Jughead assures him that he has his back, no matter what. Before they can elaborate an opinion, Sheriff Keller arrives to question Archibald. They all give them privacy. Jug figured this would be a good time to talk to Betty, yet she ignores him calling out for her and leaves to the cafeteria with Ronnie.

After long tedious, yet uneasy waiting hours, the surgeon and nurses come out of the hallway. Archie immediately stands up and the man signs with his hand he’ll soon speak to them. First he stops at the reception desk in the waiting room, giving Fred’s chart and further instructions to a girl who looks too young to be in scrubs, in Jug’s opinion. She removes her bouffant cap to reveal a Y/L/H/C and makes eye contact with Jughead, who looks away quickly, embarrassed, feeling his face get warm and red. Reason tells him it’s immoral to blush from looking at a girl he doesn’t even know while having a girlfriend - and being at the hospital with his best friend’s dad just out of surgery makes it ten times worse. Truth is he just can’t help it.

The man introduces himself as Dr. Stone, the general surgeon who operated on Mr. Andrews. He calmly and rationally explains they managed to remove the bullet and cease the bleeding. Then he tells Archie his dad is being taken to the ICU and he’ll soon be able to see him. Despite that, Fred’s still intubated and they don’t know how long it will be until he wakes up, considering the bullet hit a vital organ. In his opinion, though, it could’ve been a lot worse. All they heard was ‘He’s alive’. Arch releases a breath he didn’t even know he was holding in. “I’m gonna stay with my dad. Can you let Ronnie know she can go home?”, the ginger boy covered in his own father’s blood cries out. “Sure. Listen, he’s gonna be fine, Archie. I’ll be back tomorrow morning so you can change and rest.” Jughead hugs his friend once more, tighter this time. He’s not big on PDA or physical contact in general, although he truly wants to express how much he cares.

Jughead walks out of the hospital, feeling the icy air cool his face. He closes his eyes, but that doesn’t stop his mind from going a thousand miles per hour. The beanie-clad boy is immensely solaced that Fred is in his way to recovery. Regardless, there is still a long way to go until it’s all put right and the dog days end. After all the hours awake, caffeine is needed. Unfortunately, his usual place for a hit is not an option. He spots a small food truck next to the parking lot. The largest cup they had still doesn’t fit his needs, but it will do. While he’s waiting for his drink, he texts Veronica as Archie asked. Jug recognises the girl sitting in one of the benches. Tiny droplets of water from the drizzle glow red and blue on top of her noteworthy hair when the ambulance lights shine.

He can’t help gazing at the girl who may have just saved Fred’s life. Something about her attracts Jughead like a magnet. “People complain about hospital food. But the coffee... is to die for.”, she remarks ironically, taking a sip from her large travel cup of coffee. Jughead takes a few seconds to realize she spoke to him, as he was standing behind her, confident he was safe from being spotted. He realizes she’s very aware of him staring. “Considering the work hours, that’s essential. Mind if I sit?”, he asks. She shakes her head in agreement and scoots over to give him more space. “Jughead Jones the Third.” He extends her a hand. “Y/N Y/L/N... the first.” She firmly and steadily shakes it.

She doesn’t look mad about him glaring. Intrigued is more like it. “You’re part of the surgical team who operated on Fred Andrews, right?”, he asks. “Technically, I’m not supposed to disclose it to non-family members. But you did see me with Dr. Stone.” She doesn’t break eye contact, and even in the low lighting he can see her beautiful Y/E/C iris, deep like a galaxy, as if a whole universe resided in it. “I just wanted to thank you. You’re part of the reason he’s still alive.” Jughead bites the inside of his cheeks trying to remain composed. “I’m just an intern.” Her words contradict her smile, as if no one has ever appreciated all the effort she puts into saving people’s lives. Y/N’s pager beeps. “Duty calls.” The girl gets up and swallows the rest of her coffee in one sip. “Is that for Fred?”, Jug asks anguished, wondering if something could’ve gone wrong. “I do have other patients, Mr. Jones.”, she replies. “Please. Call me Jughead.”, he says. “See you around, Jughead.”, Y/N speaks louder as she’s already walking away.

“Juggy?” He hears Betty calling out for him seconds after Y/N left, exactly the same way she did back at the trailer. For the first time, that annoys him. Jughead feels he’s being treated like a child and a possession. None of them have the energy to deal with their situation at the moment. She offers him a ride home, which he denies saying he needs to clear his mind. The blonde girl tried to peck his lips but he turns his face and she lands a soft kiss on his cheek. “We’ll talk tomorrow.”, he guarantees and leaves.

He still has the spare key Fred gave him when he moved in. Entering the empty house feels weird. Jughead climbs the stairs to the room he used to share with Archie to pack him some clean clothes and essentials. Practicality dictates he should spend the night there, as he has to talk to Betty before going to the hospital the next morning. On second thought, the place doesn’t feel like home anymore and the silence is driving him mad.

Jug crosses Riverdale’s train tracks towards the south, carrying the northside mess with him inside Archie’s Bulldog football bag. Sunnyside’s sign gives him comfort for the first time in a really long while. He gets inside his dad’s trailer, rests the bag on the kitchen table and throws himself at the couch, dog-tired. Still his brain doesn’t want to fall asleep. He stares at the leather jacket carefully placed at the back of the chair. It has a strong effect on him, like it’s seducing him. He gives in to temptation and puts it on again. Just as the first time, he feels sheltered and powerful. That can only lead him one place at this hour.

The red doors loosely remind him of the ones at Pop’s. If not for the bikes parked in front, he could trick himself. Not that he needs to. Somehow, the Whyte Wyrm feels a lot safer in relation to the chock’lit shoppe now. Usually, he'd feel like a pray walking in the bar filled with snakes to retrieve his drunken father. Now he feels nested, welcomed and comfortable. “Glad to see you again, kid”, the man who gave him the jacket pats his back respectfully. “Truth be told we weren’t sure you would.”, the young guy who held Hot Dog’s leash the previous night confesses, preparing to shoot the pool ball. He pockets the 8, ending the game and retrieving the bet money. “Come on, I’ll buy you your first beer.” Jughead just walks with him to the counter, still silent, taking in every detail of the bar he missed the previous times. The pictures on the wall, neon signs shading the dark room, people having fun, the snakes inside the glass tanks, but most surprising of all, Y/N Y/L/N sitting at the counter.

“Aren’t you a little young to be in a bar?” He’s amazed and a little scared as once again she addresses him facing the other way. “Do you have eyes in your back?” He sits down on the empty stool next to her and the young serpent winks at him with a smirk. Jughead widens his eyes to him, wordlessly telling him to scram. “Surgeon skills, I have to be aware of at least 5 other people in the OR while keeping my eyes on the patient.”, she explains, shifting her stool towards him. “Impressive. And I am.”, he says, sipping his cold beer, still not sure the glory everyone sees in it. “I won’t tell if you won’t.” She shows him her driver's license, Y/B/M/D 2000. “How are you a doctor if you’re still 17?”, he asks. “Skipped high school. I have an eidetic memory, didn’t wanna waste four perfectly good years of a very short life in hell, so I just got my GED and got into Med school.”, she says like it’s not a big deal. “Doctor Strange much?” He wonders if she’ll even get the reference. “Wouldn’t that be awesome?” Y/N bumps the rim of her bottle to Jughead’s.

A couple of beers in and Jughead is already tipsy, although unable to forget the messed-up things that have been happening in a row. “What do you think happened?”, he asks Y/N in relation to the Pop’s shooting. “Robbery gone wrong. I haven’t given it much thought to be honest.” Y/N stands up and grabs Jughead’s hand making him come with her. “How could you not have thought about it?”, he asks, simply letting her guide him. “I’m a doctor, Jughead. I have to think about charts and keeping my patients alive. I leave detecting to the Sheriff.” Y/N rests her beer bottle in the corner of the pool table. “Pardon me if I don’t trust the police.”, he says, still confused as to why they got up. “You’re one of the kids who solved the Jason Blossom murder case, wouldn’t expect anything else.” She starts setting the balls inside the triangle. “Not in the least. Found it quite impressive actually. I’m all for justice. It’s just that I left a 16-hour shift, the only thing I want to do is drink and play.” She grabs two cue sticks and hands one out to Jughead. “Come on. If I win, you buy me a drink; if you win, you buy me a drink.”, she says playfully. “Fair game you got going, huh?” Jug starts chalking his stick to start the game.

Surprisingly, he’s pretty good at it. Not only for his first time playing, but being drunk while doing it. “Dr. Y/N/N. You’re not going easy on our boy here, are you?”, one of the serpents says, leaning on the table. “Are you accusing me of cheating, Franky?”, she tells him. “Maybe you could let him win so we can get out of here.”, the young southsider suggests. The boy places his hands on either side of her, pinning her to the table. Jughead watches furiously but unable to act. He wants to punch him but he’s one of them now and can’t just go around hitting the guys.“In your dreams.” She pushes him away and grabs Jug’s hand once more taking control. As they leave the bar, he realizes how dizzy he is. But Y/N is steady enough to hold him upright.

They walk past the gates of Sunnyside trailer park. Jughead is leaning in Y/N for support. She leads him and herself towards his trailer according to Jug’s direction. After they walk around the same place twice, she declares them lost and Jughead unfit to guide. Half an hour of that wandering through the trailer park passes until they finally arrive at the improvised porch of Y/N’s trailer. She drops an almost unconscious Jughead on her bed, pulling his jacket off with a lot of difficulty, as he wanted to keep it on, covering him with a blanket after untying his shoes. Y/N fills a glass of water and takes some ibuprofen to her bedside desk along with a note instructing Jughead to close the trailer door when he leaves and drop the key in the plant at the bottom of the porch stairs. Y/N watches the boy sleeping in her bed. He looks serene, unlike when he’s awake. She grabs a blanket for herself to sleep in the couch.

[professorexcel]

FIND & SEARCH in Excel: How and When to Use These Formulas

The two formulas FIND and SEARCH in Excel are very similar. They search through a cell or some text for a keyword or character. Once found, they return the number of characters, at which the keyword starts. Let’s learn how to use them and explore the differences of the two formulas.

  How to use the FIND formula

The formula returns the number of the character, at which your search term starts. If your text can’t be found, it’ll return a “#VALUE” error.

  Structure of the FIND formula

The FIND formula has at least two arguments: The SEARCH TERM as well as the “WITHIN TEXT”. The third part is optional.

The structure of the FIND formula is quite simple (the numbers are corresponding to the image on the right-hand side):

SEARCH TERM: The first part of the formula is the text you look for.

WITHIN TEXT: The cell or text you want to search your “SEARCH TERM” in.

START NUMBER: This argument is optional. If you don’t want to start searching at the beginning of the text, fill in the number larger than 1, otherwise just type 1 or leave it blank.

If you just want to know, if your text can be found within another cell, you might want to go with the following formula. B2 contains the text or character you search for and B3 is the cell you search in:

=IFERROR(IF(FIND(B2,B3)>0,"Value found",""),"Value not found")

Please note the following comments:

FIND is case-sensitive. That means, it matters if you use small or capital letters.

You can also search for numbers within another number. For example:

=FIND(1,321)

This formula returns 3 because the number 1 is the third character of 321.

You can’t use wildcard criteria (“*” or “?”) with the FIND formula.

Please refer to this article if you want to know more about the IF formula and to this article for more information about the IFERROR formula.

  Examples for the FIND formula

Let’s try some examples.

  Example 1: Find the first occurrence

Example 1: Find “o” in “Hello there”.

The “default” usage of the FIND formula is to return the number of characters, at which a text first occurs within another text. Let’s say you have the text “Hello there” and want to know, at which position you have an “o”. In such case, you write the following formula (example number 1 in the Excel workbook you can download at the end of this article).

=FIND("o","Hello there")

The return value is 5.

.aq_block_15138 h1 { color: ; } .aq_block_15138 p { color: ; }

(adsbygoogle = window.adsbygoogle || []).push({});

  Example 2: Find the first occurrence after the third character

Example 2: Get the position of the first “e” after the third character.

Another example: You want to know the position of “e” after the third character (example number 2 in the example workbook).

=FIND("e","Hello there",3)

The return value is 9.

  Example 3: Find the second occurrence

Example 3: Get the position of the second “e” in “Hello there”.

Now you want to know the position of the second occurrence of “e” in “Hello there”.

=FIND("e";"Hello there";FIND("e";"Hello there")+1)

This formula works as follows. The second FIND formula returns the position of the first occurrence of “e” in “Hello there” which is 2. This is used as the START NUMBER (+ 1 because you want to start counting after the first “e”) for the first FIND formula.

  Example 4: Find the last occurrence

Example 4: Get the position of the last occurrence of “e” in “Hello there”

Finding the last occurrence of a string within a text is a little bit more complicated. You use SUBSTITUTE and LEN. The complete formula is like this:

=FIND("tempreplacetext";SUBSTITUTE("Hello there";"e";"tempreplacetext";SUM(LEN("Hello there")-LEN(SUBSTITUTE("Hello there";"e";"")))/LEN("e")))

In order to understand the formula better, let’s start in the middle with the part 

SUM(LEN("Hello there")-LEN(SUBSTITUTE("Hello there";"e";"")))/LEN("e")))

This part of the formula determines the number of “e” in “Hello there”. It replaces “e” in “Hello there” and the difference in the two versions (with and without e – “Hello there” and “Hllo thr”) is the number of “e”s.

The whole part 

SUBSTITUTE("Hello there";"e";"tempreplacetext";SUM(LEN("Hello there")-LEN(SUBSTITUTE("Hello there";"e";"")))/LEN("e")))

 replaces the last “e” by “tempreplacetext”. Now you just put this into the FIND formula and get the position of “tempreplacetext”.

If you want to use this formula, replace all “e”s by your cell reference for the SEARCH TEXT and all “Hello there” by the cell reference to your WITHIN TEXT.

  .aq_block_23038 h1 { color: ; } .aq_block_23038 p { color: ; }

Excel too slow? Speed it up. Get the book now!

.aq_block_63038 h1 { color: ; } .aq_block_63038 p { color: ; }

Tired of waiting for Excel? Use the 30 best methods described in this book to speed up Excel calculations!

Learn how Microsoft Excel performs calculations

Use the simple and effective step-by-step guide to master each method

Get to know the impact each method will have on performance

Learn more or get it on Amazon!

  Replace text enclosed by brackets

Example 5: Return the text between the brackets of “Hello (you) there”.

A last example for the FIND formula: You want to know what is written between two brackets. In such case, you can also use the FIND formulas in combination with the MID formula.

=MID("Hello (you) there",FIND("(","Hello (you) there")+1,FIND(")","Hello (you) there")-FIND("(","Hello (you) there")-1)

The MID formula returns some part of text from a (longer) text. It has three arguments:

The initial, complete text.

The starting character for the text you want to get.

The length (in number of characters) of text you want to extract.

In our example above, the first FIND formula provides the character you want to start at. In our case that’s the first opening bracket (+1 because you want to start one character later). The second and third FIND formulas determine the length by

    How to use the SEARCH formula

Like the FIND formula in Excel, SEARCH also returns the position of a text within another text.

  Structure of the SEARCH formula

The SEARCH formula has the same arguments as the FIND formula.

The SEARCH formula is very similar to the FIND formula. It has exactly the same arguments and works the same way.

Because of the, the structure is as follows:

The SEARCH TERM is the text or character you search for.

WITHIN TEXT contains the text you search in.

The START NUMBER is optional and defines the number of character, after which Excel should start searching.

Yes, you are right – these arguments are exactly the same like in the FIND formula. But there is a major difference: SEARCH does not regard lower and upper case: It is not case sensitive. FIND on the other hand is case-sensitive and regards upper and lower cases.

.aq_block_15138 h1 { color: ; } .aq_block_15138 p { color: ; }

(adsbygoogle = window.adsbygoogle || []).push({});

  Examples for the SEARCH formula

The examples work exactly the same way like for the FIND formula. You only have to replace “FIND” by “SEARCH”. Because of that, we just show the summary below. If you want to know more, either scroll up to the “FIND”-examples or download the example workbook below.

Example no.  Description Formula 6 Return the position of “o” in “Hello there”. =SEARCH(“o”,”Hello there”) 7 Return the position of “e” in “Hello there” after the third character. =SEARCH(“e”,”Hello there”,3) 8 Return the position of the second occurrence of “e” in “Hello there”. =SEARCH(“e”,”Hello there”,SEARCH(“e”,”Hello there”)+1) 9 Return the position of the last occurrence of “e” in “Hello there”. =SEARCH(“tempreplacetext”,SUBSTITUTE(“Hello there”,”e”,”tempreplacetext”,SUM(LEN(“Hello there”)-LEN(SUBSTITUTE(“Hello there”,”e”,””)))/LEN(“e”))) 10 Return the text within brackets of “Hello (you) there”. =MID(“Hello (you) there”,SEARCH(“(“,”Hello (you) there”)+1,SEARCH(“)”,”Hello (you) there”)-SEARCH(“(“,”Hello (you) there”)-1)

  Troubleshooting

The error message “#VALUE!” comes up most often for the FIND and SEARCH formulas. If you receive a “#VALUE!” error, please check the following possibilities.

Make sure your SEARCH TERM can be found. If it can’t be found, you’ll receive the #VALUE! error.

The last argument, the START NUMBER, is larger than the number of characters of in your WITHIN TEXT argument.

You haven’t provided the last argument although you wrote the comma. For instance =SEARCH(“b”,”abc”,).

Please check, if your SEARCH TERM and WITHIN TEXT have the same format. You can’t search for a letter or text in a number cell.

    Difference between FIND and SEARCH

The first and major difference between FIND and SEARCH:

FIND is case-sensitive. SEARCH is not case-sensitive.

That means, FIND regards capital and small letter whereas SEARCH doesn’t.

How to remember which is which? I use the mnemonic:

FIND finds exactly what you look for.

Searching for something also searches for roughly what you look for.

I admit, it’s not the best mnemonic. Please let me know, if you have a better one!

  There is also a second difference between FIND and SEARCH: You can use SEARCH with wildcard criteria within the SEARCH TERM.

“?” stands for a single character. Example:

=SEARCH("?b","abc")

“*” matches any sequence of characters.

=SEARCH("*b","abc")

If you want to search exactly for ? or *, write a tilde in front of them. Example:

=SEARCH("~*","ab*c")

.aq_block_23554 h6 { color: #ff6200; } .aq_block_23554 p { color: ; }

Hold on a second. Was this information helpful so far?

.aq_block_53554 h3 { color: #2b803f; } .aq_block_53554 p { color: ; }

If yes: Why don't you subscribe to our monthly, free Excel newsletter? You get all this:

.aq_block_63554 h1 { color: ; } .aq_block_63554 p { color: ; }

The best Excel tips, tricks and tutorials. 1x per month. No spam. Promised.

.aq_block_93554 h1 { color: ; } .aq_block_93554 p { color: ; }

Your welcome gift: Our big 45 pages keyboard shortcuts package.

.aq_block_123554 h1 { color: ; } .aq_block_123554 p { color: ; }

Subscribe now!

.aq_block_133554 h1 { color: ; } .aq_block_133554 p { color: ; }

#mc_embed_signup{clear:left; font:14px Helvetica,Arial,sans-serif; } /* Add your own MailChimp form style overrides in your site stylesheet or in this style block. We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. */

(function($) {window.fnames = new Array(); window.ftypes = new Array();fnames[0]='EMAIL';ftypes[0]='email';fnames[1]='FNAME';ftypes[1]='text';}(jQuery));var $mcj = jQuery.noConflict(true);

Learn more

Differences between FIND and FINDB as well as SEARCH and SEARCHB

Maybe you have noticed that there is also a slightly different version of the two formulas in Excel. If you add a “B” to the formulas, you can still use them the same way. So what is the difference?

FINDB and SEARCHB provide support for more complex languages. The definition by Microsoft is:

SEARCHB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise SEARCHB behaves the same as SEARCH, counting 1 byte per character.

According to Wikipedia DBCS stands mainly for the Asian languages Chinese, Japanese and Korean.

  Download

Please feel free to download all the examples shown above in this Excel file.

Click here and the download starts immediately.

Was the information helpful in this article?

If yes, why don’t you subscribe to our free, monthly Excel newsletter?

If no, please let us know what to improve.

.aq_block_15138 h1 { color: ; } .aq_block_15138 p { color: ; }

(adsbygoogle = window.adsbygoogle || []).push({});

Der Beitrag FIND & SEARCH in Excel: How and When to Use These Formulas erschien zuerst auf Professor Excel.

from Professor Excel http://ift.tt/2wu1U47