Extract Mid text from cell

[CassieL]

Hi everyone, I am new to excel, I am trying to extract middle text from the cell. For example:

("111111")
("222")
("5555")

I want return :
111111
222
555

Please advised!

 

[alansidman]

Assume data in column A
type in B1 =MID(A1,FIND("""",A1)+1,LEN(A1)-4) and copy down

 

[Michael M]

And if you want to convert the result to numbers use....

=MID(A1,FIND("""",A1)+1,LEN(A1)-4)+0

 

[CassieL]

Hi, it gives me the string end with "), for example" 222"), how to get rid of the ")

 

[CassieL]

Hi Michael, it returns #Value error

 

[Michael M]

Are the strings you posted in post #1 EXACTLY correct ??
Make sure there are no spaces in the string !!

 

[CassieL]

Hi Michael, yes it is correct, there is no space in between. The text string is closed with ("")

 

[Michael M]

In another space nearby type
=Len(A1)
assuming the ("111111")is in A1

Do you get 10 as the result ???

 

[alansidman]

Using your example, I used the formula I posted and it returned the expected results you provided in my spreadsheet.

 

[jtakw]

Hi,

I'm fairly sure you have leading and/or trailing spaces, give this a try:

Excel 2010
	A	B	C
1	(" 111111 ")		111111
2	( "222")		222
3	( "55 55" )		5555
Sheet1

Cell Formulas
Range	Formula
C1	=--MID(SUBSTITUTE(A1," ",""),FIND("""",SUBSTITUTE(A1," ",""))+1,LEN(SUBSTITUTE(A1," ",""))-4)