OK. I figured out how to get the ISBN and the FORMAT:

=FIND("ISBN:",B2) <<--enter this formula in a new "finding" column
=MID(B2,K2+6,13) <<-- Enter this formula in the ISBN column
then convert formula to value and delete the "finding" column

=FIND("Format:",B2) <<--enter this formula in a new "finding" column
=MID(B2,N2+8,9) <<--enter this formula in the FORMAT column
then convert formula to value and delete the "finding" column

What I'm not how trouble with is the Author/Editor column because the
names are all variable lengths. Still working on it.

Barb


The Moose wrote:
I have a paragraph in a spreadsheet, like so:

-----------------------
1,000 Vegetarian Recipes by: Gelles, Carol DESCRIPTION: ISBN:
0-02-542965-5 Title: 1,000 Vegetarian Recipes Author: Gelles, Carol
Category: Cooking, Food Wine : Baking : General Publisher: John Wiley
Sons Inc Date: May 1996 Format: Hardcover Condition: Used; Very Good
Seller's Notes: Small smudge on the inside fold of the dustcover.
Record Number: 328 ABOUT THE BOOK: Book Description Not just for
vegetarians, there's never been a better time for this award-winning
book! Carol Gelles, one of t
-----------------------

Is there any way to extract the ISBN ('0-02-542965-5' in the example
above) and the Author ('Gelles, Carol' in the example above) and the
Format ('Hardcover' in the example above)??

These columns are extracted from a data-source that cannot be modified.
All of the paragraphs that will be extracted are not in exactly the
same format -- some of them say "editor" instead of "author" and, of
course, the information in the paragraph is all different lengths.

Thanks.

Barb