Sheeloo, Nice work, that did it..

Ty
--
Thanks, Ty


"Sheeloo" wrote:

Try
=RIGHT(A2,LEN(A2)-FIND("^",SUBSTITUTE(A2,"-","^",4)))

assuming your text does not contain the character "^". If it does then you
will have to replace it with a character which will not be there...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Ty" wrote:

I have a a column of data that has 4 seperate hyphens in the text.
EX. abc-123-abc-123-BEGIN NEEDED DATA AND THIS DATA ALSO HAS HYPHENS I WANT
TO KEEP.

How can I remove all the data that preceeds the 4th and final hyphen and
keep the needed data. The # of characters in the preceeding data varies, so
the 4th hyphen ( from the left) is the only consistent measure I have.

--
Thanks, Ty