software

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.



quot;Katie59quot; wrote:

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

Hi!

Try this:

Select the cell(s) in question
Goto Editgt;Replace
Find what: -?????
Replace with: nothing, leave this blank
Replace all

Biff

quot;Katie59quot; gt; wrote in message
...
gt; Sorry about this, but I've searched and searched and don't see that HELP
gt; addresses this. I need to remove a dash followed by a sequesnce of 5
gt; numbers. The 5 #'s are different in each cell.
On Thu, 23 Mar 2006 10:09:28 -0800, Katie59 gt;
wrote:

gt;Sorry about this, but I've searched and searched and don't see that HELP
gt;addresses this. I need to remove a dash followed by a sequesnce of 5
gt;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,quot;-\d{5}quot;)

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

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

quot;Ron Rosenfeldquot; wrote:

gt; On Thu, 23 Mar 2006 10:09:28 -0800, Katie59 gt;
gt; wrote:
gt;
gt; gt;Sorry about this, but I've searched and searched and don't see that HELP
gt; gt;addresses this. I need to remove a dash followed by a sequesnce of 5
gt; gt;numbers. The 5 #'s are different in each cell.
gt;
gt; What's in the rest of the cell? Depending, you may be able to do this with
gt; regular worksheet functions. However, you can easily do this with a regular
gt; expression:
gt;
gt; =REGEX.SUBSTITUTE(A1,quot;-\d{5}quot;)
gt;
gt; You'll have to download and install Longre's free morefunc.xll add-in from
gt; xcell05.free.fr to use this.
gt; --ron
gt;

gt;Then simply delet the newly formed column.

You don't need to do that.

In Step 3 of the T to C Wizard, you can click on the column of numbers and
then select Do not import column (skip).

Biff

quot;Sid1962quot; gt; wrote in message
...
gt; Why not just select the column, and use Text to Columns. When the window
gt; comes up, make sure Delimited is checked. Then select Other, out in a
gt; dash,
gt; and say OK. It creates a new column to the right of the original, with
gt; all
gt; of the numbers that were to the right (following) the dash. The dash
gt; disapperas. Then simply delet the newly formed column. I treid it with a
gt; column of 6 or so numbers, and it worked for me.
gt;
gt; Good Luck.
gt;
gt; Sid1962
gt;
gt; quot;Ron Rosenfeldquot; wrote:
gt;
gt;gt; On Thu, 23 Mar 2006 10:09:28 -0800, Katie59
gt;gt; gt;
gt;gt; wrote:
gt;gt;
gt;gt; gt;Sorry about this, but I've searched and searched and don't see that HELP
gt;gt; gt;addresses this. I need to remove a dash followed by a sequesnce of 5
gt;gt; gt;numbers. The 5 #'s are different in each cell.
gt;gt;
gt;gt; What's in the rest of the cell? Depending, you may be able to do this
gt;gt; with
gt;gt; regular worksheet functions. However, you can easily do this with a
gt;gt; regular
gt;gt; expression:
gt;gt;
gt;gt; =REGEX.SUBSTITUTE(A1,quot;-\d{5}quot;)
gt;gt;
gt;gt; You'll have to download and install Longre's free morefunc.xll add-in
gt;gt; from
gt;gt; xcell05.free.fr to use this.
gt;gt; --ron
gt;gt;