VBA，在列中搜索特定字符，提取该字符的字符串

In a specific column, I want to search for a specific character in cells...say "(" or "/". Once this character is found in a cell, I want to extract the part from the beginning of the string upto the point that this character is found, in the cell adjacent to it.In a specific column, I want to search for a sp