unwanted concatenation
Need to delete appended character string from valid data
in cells in one column (B), so B2:B500. Data in the cells
is of varying length, but the unwanted appended char
string is always 14 characters (including the preceding
<space). In the following example, I want to delete
everything following "Smith John". Characters vary within
the parenthesis, but always this format.
Example:
Smith John (x_cc24_g011)
Is there a way to delete the unwanted string by counting
from the right? Or, by copying the data to the left of
this string to another column?
Thanks for your help,
Randy
|