Extracting Data

Dave · Apr 20, 2004

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 · Apr 20, 2004

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

Dave · Apr 20, 2004

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 · Apr 20, 2004

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

Dave · Apr 20, 2004

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

.