Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
COUNTIF formula multiple text exclusions | Excel Discussion (Misc queries) | |||
formula OR text | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |