How to remove a character from a string using a formula

[smalik]

I know it is very simple, but I can't seem to figure out the Find/replace or Find/Substitute formula. or is there a Find/Remove formula?

I have a cell with column with US zip codes. Some values are only 5 digits and some are 10 (5 digits plus "-" plus 4 digits)

For example,
51301-7569 or
51360

How do I remove the "-" from the data?

For example, 51301-7569 should turn into 513017569 and if there are only 5 characters then leave the value as is, i.e., 51360 should stay as 51360

I used the find function that gives me the value of 6. This tells me that the "-" is at the six spot. I just can't figure out how to remove this "-"

Any help is greatly appreciated.

Thanks.

 

[Phuoc]

Try this

Book1
	A	B
1	51301-7569	513017569
2	51360	51360
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=SUBSTITUTE(A1,"-","")

 

[smalik]

Awesome.... This works. Thank you.

I think I made it too complicated by going in the "FIND" direction.

Once again, Thanks for saving me time.