View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy[_11_] Randy[_11_] is offline
external usenet poster
 
Posts: 18
Default 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