Remove the - from a zip+4 cell

  • Thread starter Thread starter Allen Clark
  • Start date Start date
A

Allen Clark

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
 
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!
==============================================

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
 
Back
Top