Extract string between two characters not working.

[RockandGrohl]

Hi all,

I'm trying to extract the string between two characters using this formula:

=MID(LEFT(K2,FIND("(",K2)-1),FIND(")",K2)+1,LEN(K2))

For instance, "DATA SHARER (1GB)" should return "1GB" and "DATA SHARER (5GB)" should return "5GB"

However, when I enter this formula, ensure it's looking at the correct cell, the formula completes and then shows a blank cell. No errors, and it's not showing me the value I need.

Has anyone encountered this before? Thank you.

 

[Fluff]

How about

=SUBSTITUTE(REPLACE(K2,1,FIND("(",K2),""),")","")

 

[RockandGrohl]

For some reason, looking between "(" and ")" doesn't work, but if I look between "(" and "GB" it seems to work just fine.

 

[Fluff]

Did you try the formula I suggested?

 

[Peter_SSs]

Has anyone encountered this before?

Yes, I have done it. It is called "using the wrong formula".

If the parentheses are always at the end then you can use the formula that Fluff suggested or you could also try this which also deals with if the parentheses if they are not at the end.

23 01 09.xlsm
	K	L
2	DATA SHARER (1GB)	1GB
3	DATA SHARER (5GB) ABC	5GB
Extract

Cell Formulas
Range	Formula
L2:L3	L2	=MID(K2,FIND("(",K2)+1,FIND(")",K2)-FIND("(",K2)-1)

 

[RockandGrohl]

Yes, I have done it. It is called "using the wrong formula".

That's my favourite trick lol.

 

[RockandGrohl]

Did you try the formula I suggested?

I did and it worked

 

[Fluff]

Glad we could help & thanks for the feedback.