On Thu, 23 Mar 2006 10:09:28 -0800, Katie59
wrote:

Sorry about this, but I've searched and searched and don't see that HELP
addresses this. I need to remove a dash followed by a sequesnce of 5
numbers. The 5 #'s are different in each cell.

What's in the rest of the cell? Depending, you may be able to do this with
regular worksheet functions. However, you can easily do this with a regular
expression:

=REGEX.SUBSTITUTE(A1,"-\d{5}")

You'll have to download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr to use this.
--ron