Remove the - from a zip+4 cell

Use a "helper" column with this formula:

=SUBSTITUTE(A1,"-","")

Copy down as needed.

Now, to remove the formulas, and leave the data behind:
Select this column, right click in the selection, and choose "Copy".
Right click again and choose "PasteSpecial",
Click on "Values", then OK.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Allen Clark" wrote in message
...
I am working on a conversion from an access DB to a SQL DB and I am using
Excel to format the text files into the formats that are required for the
data conversion scripts to run. I have several zipcode fields that have 5
or 9 digit zipcodes. Most of them have a - in the sixth position. In order
to format the data correctly, I must remove the - from the cell. Can anyone
recommend a way to remove the - and leave a 5 or 9 digit text value?

Thanks in advance,
Allen

=SUBSTITUTE(A1,"-","")

Worked like a champ!

Thanks for the assistance!


"RagDyer" wrote in message
...
Use a "helper" column with this formula:

=SUBSTITUTE(A1,"-","")

Copy down as needed.

Now, to remove the formulas, and leave the data behind:
Select this column, right click in the selection, and choose "Copy".
Right click again and choose "PasteSpecial",
Click on "Values", then OK.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Allen Clark" wrote in message
...
I am working on a conversion from an access DB to a SQL DB and I am using
Excel to format the text files into the formats that are required for the
data conversion scripts to run. I have several zipcode fields that have 5
or 9 digit zipcodes. Most of them have a - in the sixth position. In
order
to format the data correctly, I must remove the - from the cell. Can
anyone
recommend a way to remove the - and leave a 5 or 9 digit text value?

Thanks in advance,
Allen