Mid statement with different length of characters

[mcdonkadonk]

I will preface this with an apology, If i broke any rules with this post, I am sorry.

My issue is as follows:

I am looking to get a set of characters using a mid statement, but the amount of characters has grown. I need to be able to get 5 and 6 characters with the same function.

My mid statement =MID(A10,9,5)

Samples of what could be in targeted cell:

Feature F6118: CR6456 Feature F10764: CR5410 <tbody> </tbody>

<tbody>
</tbody>

I need a mid statement that can pull the F#### or F#####.

Please and thank you for any help. I was thinking somehow selecting what is between the " " and ":" which would be great for future purposes since the numbers keep growing.

 

[Norie]

Try this.

=SUBSTITUTE(LEFT(A1,SEARCH(":",A1)-1),"Feature ","")

 

[Gerald Higgins]

Hi, welcome to the board, if you just want everything after the ":" character, maybe something like this

=MID(A10,FIND(":",A10,1)+1,5)

Or

=MID(A10,FIND(":",A10,1)+1,100)
if the number of characters after the : can vary and you want all of them.

 

[mcdonkadonk]

That worked Perfectly!!!!! Thank you, I am going to try to figure out what this means.

 

[mcdonkadonk]

Try this.

=SUBSTITUTE(LEFT(A1,SEARCH(":",A1)-1),"Feature ","")

The thank you was for this^^ Im still learning the way the reply function works apparently.

 

[mcdonkadonk]

Hi, welcome to the board, if you just want everything after the ":" character, maybe something like this

=MID(A10,FIND(":",A10,1)+1,5)

Or

=MID(A10,FIND(":",A10,1)+1,100)
if the number of characters after the : can vary and you want all of them.

I will try this out as well. Thank you for your help!