Forum Discussion

Guru Ijare's avatar
Guru Ijare
Copper Contributor
Sep 11, 2018
Solved

Need to add slash between no in the excel cell

Hi Experts, Do help me formatting the cell by inserting slash between no's   Input: 1234 Output:1/2/3/4   Please Help
excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Sep 11, 2018

    Yes, it is.

     

    #"/"#"/"#"/"#

     

Guru Ijare's avatar
Guru Ijare
Copper Contributor
Sep 11, 2018
Hi is it possible to make by using format sell tab please ?
Since placing formula is always difficult
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Sep 11, 2018

    Yes, it is.

     

    #"/"#"/"#"/"#

     

    • Guru Ijare's avatar
      Guru Ijare
      Copper Contributor
      Sep 11, 2018

      Thanks Ton,

      But it is not working for Two Digits.

      Example

      Input: 101055

      Output: 10/10/5/5

      Please Help

       

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Sep 11, 2018

        Your specifications change with every post. This could go on for years. Please clarify.

         

        ##"/"##"/"#"/"#

         

Resources