3 Replies Latest reply on Aug 14, 2018 1:22 AM by Paulo Dantas

    How to change the cell format?

    Yun Feng

      Hi

       

      I have data like this in worksheet:

      标题 1标题 2标题 3标题 4标题 5
      ProductA_HA_LB_HB_L
      Q0.10.20.30.4

      how to change it to:

       

       

      ProductAB
      ALHLH
      0.10.20.30.4

       

      Thanks!