ExcelBanter - Can Search find 2 or more "/"?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can Search find 2 or more "/"? (https://www.excelbanter.com/excel-discussion-misc-queries/14379-can-search-find-2-more-%22-%22.html)

Wind54Surfer

Can Search find 2 or more "/"?

Hi everyone,

I believe now I am asking too much.

I use (as prescribed by this group)

=ISNUMBER(SEARCH("/",D5)) to find "/" in a cell.

I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/)

Right now it does not differentiate if is 1 or more instances.

Is it possible?

Thanks for any help,

Emilio

JE McGimpsey

One way:

=(LEN(D5)-LEN(SUBSTITUTE(D5,"/",""))) =2

In article ,
Wind54Surfer wrote:

Hi everyone,

I believe now I am asking too much.

I use (as prescribed by this group)

=ISNUMBER(SEARCH("/",D5)) to find "/" in a cell.

I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/)

Right now it does not differentiate if is 1 or more instances.

Is it possible?

Thanks for any help,

Wind54Surfer

You guys are magicians!

Thanks again,

Emilio

"JE McGimpsey" wrote:

One way:

=(LEN(D5)-LEN(SUBSTITUTE(D5,"/",""))) =2

In article ,
Wind54Surfer wrote:

Hi everyone,

I believe now I am asking too much.

I use (as prescribed by this group)

=ISNUMBER(SEARCH("/",D5)) to find "/" in a cell.

I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/)

Right now it does not differentiate if is 1 or more instances.

Is it possible?

Thanks for any help,

All times are GMT +1. The time now is 05:37 AM.