Extracting text from a cell

[rbd66]

Hello!

This is probably quite basic, but I would like to know how to extract a section of a line of text, that goes as follows:

Beam Property 213 "L2-3 SC088A"

I would like to extract the L2-3 SC088A section.

I knwo the Right(), Left(), and Mid() functions, but the length are all quite different, and I can't get it to find the " symbol as obviously that doesn't work.

Any suggestions?

Thanks!

[acerrhod]

try this
=RIGHT(A32,LEN(A32)-FIND("""",A32)+1)

[duanzhuanming]

Hi,
Another formula:

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

[rbd66]

The second is more what I was looking for!

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

Thanks guys!