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