Replacing a random string of 5 numbers
 

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.

Replacing a random string of 5 numbers
 

"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. I need to remove both the dash and the numbers.

Replacing a random string of 5 numbers
 

Hi!

Try this:

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

Biff

"Katie59" wrote in message
...
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.

Replacing a random string of 5 numbers
 

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

Replacing a random string of 5 numbers
 

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

Replacing a random string of 5 numbers
 

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

"Sid1962" wrote in message
...
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