Forum Discussion
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
Yes, it is.
#"/"#"/"#"/"#
Just go >data>text to columns>fixed with>destination as $B$1 ( if the first cell you are using is A1 ) >then place the margin line just where you want to add the slash (please not using this form 01032020 input in cell will help you easily divide it into 01 03 2020) > use this =CONCATENATE(B1,"/",C1,"/",D1) Guru Ijare