Formula

[KatSlif]

Hi

I need to extract the text from inside the " "

Example:

1^/CLIN["KATHERINE"],
[TABLE="width: 175"]
<tbody>[TR]
[TD]1^/CLIN["PETER"],[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

Can you help please?

Kind Regards
Katherine

 

[jmacleary]

Hello

I am sure there are much more elegant ways than this, but this will work on cell A1:

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

 

[Marcílio_Lobão]

Katherine, Good morning.

Suppose your data at A1

Try to use:

=MID(A1;SEARCH("~""";A1)+1;(LEN(A1)-SEARCH("~""";A1))-3)

Is that what you want?
I hope it helps.