Discussions

Expand all | Collapse all

Quickly Remove Dashes From Fields

  • 1.  Quickly Remove Dashes From Fields

    Posted 07-01-2018 21:41
    I want to remove the hyphens with a formula . Can you please tell me how this can be done?

    0-54642-00104-8

    https://www.screencast.com/t/kGSX4UpVdcGd


  • 2.  RE: Quickly Remove Dashes From Fields

    Posted 07-01-2018 22:18
    List("",
    Part([UPC],1,"-"),
    Part([UPC],2,"-"),
    Part([UPC],3,"-"),
    Part([UPC],4,"-"),
    Part([UPC],5,"-"))

    You do as many PARTS as you think there could possibly be hyphens.   Extra PARTS won't hurt.


  • 3.  RE: Quickly Remove Dashes From Fields

    Posted 07-01-2018 22:23
    Thanks Mark 

    You are so good, I wish I have your knowledge