Thread
:
Copy String to the Right of "hyphen"
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Copy String to the Right of "hyphen"
=MID(A3,FIND("-",A3)+1,1024)
HTH
--
AP
"ConfusedNHouston" a écrit dans
le message de news:
...
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....
Reply With Quote