Copy String to the Right of "hyphen"

Giganews Newsgroups
Subject: Copy String to the Right of "hyphen"
Posted by:  ConfusedNHouston
Date: Mon, 1 May 2006

I have a column of data that includes a product name along with a code for a
particular container type.  The name and code are separated by a hyphen.  For
example AB1222-10, AB1222-330OW, AB1222-330OWPCFL.

As you can see, the string to the right of the hyphen varies in length and
it can be either alpha, numeric, or a mix.

How can I generate a column that contains only the text to the right of the
hyphen?  Example (based on above):  10, 330OW, 330OWPCFL as cell values in
the column.

Thank you....

Replies