bill151515
Board Regular
- Joined
- May 19, 2005
- Messages
- 87
i am using a macro that loops thru and peforms a function based on wheter or not a cell has certain characters of text in it . currently it is the first 5 characters - "hello" so i am using left("hello",5) as the check ...
however the hello may show up at the end or in the middle ... ex "sayhello", "sayhellotoday" so the left("hello",5) may not always work ... is there something similar to the left() function that can be used to see if the characters are there whether they are the first 5 last 5 or somewhere in between???? basically just looking for the presence of the predefined string "hello" anywhere in the cell??
however the hello may show up at the end or in the middle ... ex "sayhello", "sayhellotoday" so the left("hello",5) may not always work ... is there something similar to the left() function that can be used to see if the characters are there whether they are the first 5 last 5 or somewhere in between???? basically just looking for the presence of the predefined string "hello" anywhere in the cell??