Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Comments on Count the number of occurrences in a text string

Post

Count the number of occurrences in a text string

+1
−1

If I have some text in a cell, how can I find the number of times another piece of text appears in it?

For example, suppose A1 contains Peter Piper picked a peck of pickled peppers.. pick occurs 2 times in this string. What formula can I put in A2 so that it counts the occurrences of pick and returns 2?

History
Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

2 comment threads

Why not fuzzy wuzzy? (2 comments)
General comments (7 comments)
General comments
pnuts‭ wrote over 3 years ago

Hi @Moshi. I would not like to have to use the long-form of question every single time on a Q&A site. Sorry, can't see what grammar you have changed. I'm not sure but I suspect a space between ] and ( breaks a link.

Moshi‭ wrote over 3 years ago

@pnuts It's a problem for me, who finds one letter long links to be difficult to see and click on. Also, I'm not holding you to anything, I just felt it would improve the post

Moshi‭ wrote over 3 years ago

Also, i didn't realize that my grammar checker added a space in there, oops. I usually turn it off when writing markdown

pnuts‭ wrote over 3 years ago · edited over 3 years ago

@Moshi I have included a summary of what I interpreted to be the original question so I hope no need to click on the [Q] - it was only there for attribution. Did you not also suggest expanding other (non-link) Qs? What about the grammar?

Moshi‭ wrote over 3 years ago

because of the Comment there -> a comment

the user currently standing top of the All Time list -> on top of

pnuts‭ wrote over 3 years ago

@Moshi "standing top" means 'in first place' ("standing on top of" is having the list underneath the user).

Moshi‭ wrote over 3 years ago

@pnuts huh, never heard that usage before. It's always been either "on top of" or "at the top of", since it needs a preposition before top

Skipping 1 deleted comment.