Sep 10 2018 10:23 PM
Hi Experts,
Do help me formatting the cell by inserting slash between no's
Input: 1234
Output:1/2/3/4
Please Help
Sep 10 2018 11:27 PM
Hello
=REPLACE(REPLACE(REPLACE(A1,4,0,"/"),3,0,"/"),2,0,"/")
Sep 10 2018 11:39 PM
Sep 11 2018 12:30 AM
SolutionYes, it is.
#"/"#"/"#"/"#
Sep 11 2018 12:43 AM
Thanks Ton,
But it is not working for Two Digits.
Example
Input: 101055
Output: 10/10/5/5
Please Help
Sep 11 2018 12:57 AM
Your specifications change with every post. This could go on for years. Please clarify.
##"/"##"/"#"/"#
Apr 02 2021 01:14 AM
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
Sep 11 2018 12:30 AM
Solution