SOLVED

Need to add slash between no in the excel cell

%3CLINGO-SUB%20id%3D%22lingo-sub-251079%22%20slang%3D%22en-US%22%3ENeed%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251079%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3EDo%20help%20me%20formatting%20the%20cell%20by%20inserting%20slash%20between%20no's%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInput%3A%201234%3C%2FP%3E%3CP%3EOutput%3A1%2F2%2F3%2F4%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20Help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-251079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2250422%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2250422%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20go%20%26gt%3Bdata%26gt%3Btext%20to%20columns%26gt%3Bfixed%20with%26gt%3Bdestination%20as%20%24B%241%20(%20if%20the%20first%20cell%20you%20are%20using%20is%20A1%20)%20%26gt%3Bthen%20place%20the%20margin%20line%20just%20where%20you%20want%20to%20add%20the%20slash%20(please%20not%20using%20this%20form%2001032020%20input%20in%20cell%20will%20help%20you%20easily%20divide%20it%20into%2001%2003%202020)%20%26gt%3B%20use%20this%20%3DCONCATENATE(B1%2C%22%2F%22%2CC1%2C%22%2F%22%2CD1)%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F190106%22%20target%3D%22_blank%22%3E%40Guru%20Ijare%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251127%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251127%22%20slang%3D%22en-US%22%3E%3CP%3EYour%20specifications%20change%20with%20every%20post.%20This%20could%20go%20on%20for%20years.%20Please%20clarify.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%23%23%22%2F%22%23%23%22%2F%22%23%22%2F%22%23%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251120%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251120%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Ton%2C%3C%2FP%3E%3CP%3EBut%20it%20is%20not%20working%20for%20Two%20Digits.%3C%2FP%3E%3CP%3EExample%3C%2FP%3E%3CP%3EInput%3A%20101055%3C%2FP%3E%3CP%3EOutput%3A%2010%2F10%2F5%2F5%3C%2FP%3E%3CP%3EPlease%20Help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251113%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251113%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20it%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%23%22%2F%22%23%22%2F%22%23%22%2F%22%23%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251099%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251099%22%20slang%3D%22en-US%22%3EHi%20is%20it%20possible%20to%20make%20by%20using%20format%20sell%20tab%20please%20%3F%3CBR%20%2F%3ESince%20placing%20formula%20is%20always%20difficult%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251092%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20add%20slash%20between%20no%20in%20the%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251092%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3DREPLACE(REPLACE(REPLACE(A1%2C4%2C0%2C%22%2F%22)%2C3%2C0%2C%22%2F%22)%2C2%2C0%2C%22%2F%22)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Experts,

Do help me formatting the cell by inserting slash between no's

 

Input: 1234

Output:1/2/3/4

 

Please Help

6 Replies

Hello

 

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

 

Hi is it possible to make by using format sell tab please ?
Since placing formula is always difficult
best response confirmed by Guru Ijare (New Contributor)
Solution

Yes, it is.

 

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

 

Thanks Ton,

But it is not working for Two Digits.

Example

Input: 101055

Output: 10/10/5/5

Please Help

 

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

 

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

 

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