Count words in text file

[hrexcel246]

Similar to a previous request by another user, how would you adjust the following? Trying to find all text that reflects the acronym "AST", whether in upper or lower case, but NOT include words that have 'ast' within other words, such as "past" or "PAST"

=IF(ISERROR(FIND(" ast"),(LOWER($D7632))),"",1)

thank you!!

 

[Aladin Akyurek]

Similar to a previous request by another user, how would you adjust the following? Trying to find all text that reflects the acronym "AST", whether in upper or lower case, but NOT include words that have 'ast' within other words, such as "past" or "PAST"

=IF(ISERROR(FIND(" ast"),(LOWER($D7632))),"",1)

thank you!!

=ISNUMBER(SEARCH(" ast "," "&$D7632&" "))+0

We get a 1 for a hit, otherwise 0.

 

[T. Valko]

Similar to a previous request by another user, how would you adjust the following? Trying to find all text that reflects the acronym "AST", whether in upper or lower case, but NOT include words that have 'ast' within other words, such as "past" or "PAST"

=IF(ISERROR(FIND(" ast"),(LOWER($D7632))),"",1)

thank you!!

Try this...

=COUNT(SEARCH(" ast "," "&$D7632&" "))

 

[T. Valko]

Try this...

=COUNT(SEARCH(" ast "," "&$D7632&" "))

Ooops!

I forgot you want a blank if not found...

=IF(COUNT(SEARCH(" ast "," "&$D7632&" ")),1,"")

 

[hrexcel246]

thank you! now it works great.

 

[T. Valko]

thank you! now it works great.

You're welcome. Thanks for the feedback!

 

[Aladin Akyurek]

thank you! now it works great.

Does that mean that you missed post #2? For the record, that works too.

 

[T. Valko]

Does that mean that you missed post #2? For the record, that works too.

I look forward to meeting you in person at the summit one of these years.

We'll have a blast!