1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help Me to Find Excel/Sheet Formula

Discussion in 'General Programming Chat' started by skyeye, Feb 10, 2017.

  1. skyeye

    skyeye Registered Member

    Joined:
    Dec 8, 2016
    Messages:
    69
    Likes Received:
    5
    Location:
    Behind You
    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.