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.
#"/"#"/"#"/"#
6 Replies
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
- Hi is it possible to make by using format sell tab please ?
Since placing formula is always difficultYes, it is.
#"/"#"/"#"/"#
Thanks Ton,
But it is not working for Two Digits.
Example
Input: 101055
Output: 10/10/5/5
Please Help
Hello
=REPLACE(REPLACE(REPLACE(A1,4,0,"/"),3,0,"/"),2,0,"/")
