Function/formula to count text string with wildcard in single cell

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,192
Office Version
365
Platform
Windows
.. so the example in post 18 was a valid example or not?
If valid, the correct count for ABC2*P* is ..?
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,102,351
Messages
5,486,358
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top