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.

     

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

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 11, 2018

Hello

 

=REPLACE(REPLACE(REPLACE(A1,4,0,"/"),3,0,"/"),2,0,"/")

 

Resources