Why not just select the column, and use Text to Columns. When the window
comes up, make sure Delimited is checked. Then select Other, out in a dash,
and say OK. It creates a new column to the right of the original, with all
of the numbers that were to the right (following) the dash. The dash
disapperas. Then simply delet the newly formed column. I treid it with a
column of 6 or so numbers, and it worked for me.

Good Luck.

Sid1962

"Ron Rosenfeld" wrote:

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