LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default formula to extract text out of a paragraph

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formula: sum a range if text present in another range NeedAdvice777 Excel Discussion (Misc queries) 10 August 29th 06 04:51 PM
COUNTIF formula multiple text exclusions [email protected] Excel Discussion (Misc queries) 4 June 1st 06 09:58 PM
formula OR text Bob Jones Excel Discussion (Misc queries) 5 August 15th 05 07:53 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"