Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find text in a string
I'm looking for a suggestion or code on finding text within a string.
For example, I have a field in an Excel spreadsheet that contains a description of a user issue. I want to categorize these descriptions by finding a specific word in the description, e.g., claim, lawsuit, refund, etc. These specific words are supposed to appear at the beginning of the description but users may place them anywhere in the description. I thought of doing using the 'mid' and cycling through the description but that doesn't seem to be a very efficient way to validate whether a specific word appears in the description. Thanks for the help... -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find text in a string
Assuming we are talking about VB code (since you posted in a programming
newsgroup and also used the keyword "Mid")... you can use the InStr function which returns the position within a larger text string where the text you are searching for is located. Since you have multiple words to search for, then you will need to loop through your keywords as you loop through your cells. -- Rick (MVP - Excel) "JT" wrote in message ... I'm looking for a suggestion or code on finding text within a string. For example, I have a field in an Excel spreadsheet that contains a description of a user issue. I want to categorize these descriptions by finding a specific word in the description, e.g., claim, lawsuit, refund, etc. These specific words are supposed to appear at the beginning of the description but users may place them anywhere in the description. I thought of doing using the 'mid' and cycling through the description but that doesn't seem to be a very efficient way to validate whether a specific word appears in the description. Thanks for the help... -- JT |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find text in a string
Say we are searching for "happiness". Try this:
Sub FindIt() Dim s As String s = "happiness" For Each r In ActiveSheet.UsedRange v = r.Value l = Len(v) v2 = Application.WorksheetFunction.Substitute(v, s, "") l2 = Len(v2) addy = r.Address If l1 < l2 Then MsgBox "You can find happiness in cell " & addy End If Next End Sub -- Gary''s Student - gsnu201001 "JT" wrote: I'm looking for a suggestion or code on finding text within a string. For example, I have a field in an Excel spreadsheet that contains a description of a user issue. I want to categorize these descriptions by finding a specific word in the description, e.g., claim, lawsuit, refund, etc. These specific words are supposed to appear at the beginning of the description but users may place them anywhere in the description. I thought of doing using the 'mid' and cycling through the description but that doesn't seem to be a very efficient way to validate whether a specific word appears in the description. Thanks for the help... -- JT |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
find text in a string
InStr function???
-- Rick (MVP - Excel) "Gary''s Student" wrote in message ... Say we are searching for "happiness". Try this: Sub FindIt() Dim s As String s = "happiness" For Each r In ActiveSheet.UsedRange v = r.Value l = Len(v) v2 = Application.WorksheetFunction.Substitute(v, s, "") l2 = Len(v2) addy = r.Address If l1 < l2 Then MsgBox "You can find happiness in cell " & addy End If Next End Sub -- Gary''s Student - gsnu201001 "JT" wrote: I'm looking for a suggestion or code on finding text within a string. For example, I have a field in an Excel spreadsheet that contains a description of a user issue. I want to categorize these descriptions by finding a specific word in the description, e.g., claim, lawsuit, refund, etc. These specific words are supposed to appear at the beginning of the description but users may place them anywhere in the description. I thought of doing using the 'mid' and cycling through the description but that doesn't seem to be a very efficient way to validate whether a specific word appears in the description. Thanks for the help... -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Find text within a string | Excel Programming | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
backwards find function to find character in a string of text | Excel Programming | |||
How to Find text in String? | Excel Programming |