I think, it's very basic. But, I don't have any experience related to Excel, so I need your help. How to transform the following data? 2/19/1995 07/5/1996 Become: 02/19/1995 07/05/1996 Second case, how to delete or remove negative character between certain number? 471-11-8688 316-80-9922 Become: 471118688 316809922 Thanks in advanced.