Extracting Data

[Dave]

I will like to create a formula that will extract dava
from a column of text that has quatation. So in the
column any text that has "" in the word extract it.

Any ideas?

I tried everything.

Thanks in advance!

 

[Frank Kabel]

Hi Dave
not quite sure about your data. could you give an example?

 

[Dave]

Thanks for your prompt responce. Let say I have a data in
a1 with the content "purple" is nice. I want to extract
just the word purple.

Thanks again.

 

[Frank Kabel]

Hi Dave
try
=MID(A1,FIND("""",A1)+1,FIND("""",A1,FIND("""",A1)+1)-FIND("""",A1)-1)

 

[Dave]

Thanks a million Frank. Your the Man!!!!!!

-----Original Message-----
Hi Dave
try
=MID(A1,FIND("""",A1)+1,FIND("""",A1,FIND("""",A1)+1)-FIND ("""",A1)-1)

--
Regards
Frank Kabel
Frankfurt, Germany



.