Try this:

=IF(MID(A1,5,1)="-",RIGHT(A1,LEN(A1)-5),A1)

Hope this helps.

Pete

On Nov 12, 3:55*pm, Mike R. wrote:
Hi -
I can't seem to figure this out, I bet it is pretty easy. *Can anyone assist?

The text is in A1.

Thanks,
Mike