What function should I use to convert 43232- to 43232
 

On the zip codes on the column Zip are in the structure of:
nnnnn- (for example, "07444-") .
What would be the function to get rid of all these "-"?

On a differnt spreadsheet I have the zips as nnnnn-mmmm.
I want to keep the nnnnn only. What function should I use?

galsaba

Take a look at

http://www.mcgimpsey.com/excel/postfixnegatives.html


In article . com,
"galsaba" wrote:

On the zip codes on the column Zip are in the structure of:
nnnnn- (for example, "07444-") .
What would be the function to get rid of all these "-"?

On a differnt spreadsheet I have the zips as nnnnn-mmmm.
I want to keep the nnnnn only. What function should I use?

galsaba

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"galsaba" wrote in message
ups.com...
On the zip codes on the column Zip are in the structure of:
nnnnn- (for example, "07444-") .
What would be the function to get rid of all these "-"?

On a differnt spreadsheet I have the zips as nnnnn-mmmm.
I want to keep the nnnnn only. What function should I use?

galsaba

You could try this for both questions:

=LEFT(A1,5)

OR
You could use <Data <TextTo Columns,
Where you choose the "Fixed Width" option.
Position the "Break Line" to separate the first 5 digits,
Then, on the next page of the wizard,
Click on Text, to retain the leading zeroes.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"galsaba" wrote in message
ups.com...
On the zip codes on the column Zip are in the structure of:
nnnnn- (for example, "07444-") .
What would be the function to get rid of all these "-"?

On a differnt spreadsheet I have the zips as nnnnn-mmmm.
I want to keep the nnnnn only. What function should I use?

galsaba