Thread
:
i need help creating a function that will extract words from a string of text
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
i need help creating a function that will extract words from a string of text
Try:
=MID(A1,SEARCH("|",A1)+1,(SEARCH("|",A1,SEARCH("|" ,A1)+1))-(SEARCH("|",A1)+1))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
wrote in message
oups.com...
i have a very long column in Excel that has the following type of
information in each cell:
Bosch|Dish|Dishwasher|Bosch Dishwasher
I'm trying to use FIND, LEFT, LEN, RIGHT, and IF to extract the word
"Dish" from the string of text.
I have a ton of these cells and they're all different, but I only need
the word left of the first "|" mark and right of the second "|" mark.
here are a few more examples of the text in each cell
Bosch|Cooking|Oven|Double|Bosch Double Convection Oven - I only want
"Cooking"
LG|Dish|Dishwasher|LG Built-In Dishwasher - I only want "Dish"
Electrolux|Fabric Care|Washer|electrolux washing machine - I only want
"Fabric Care"
Could anyone help me?
Brady
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann