Suppose my cell contains 5 . I want 5/5/5 in cell B of excel sheet.Like A 5 B 5/5/5 A 10 B 10/10/10 How to do it in excel sheet using any function?Any help?enter code here
A 5
B 5/5/5
A 10
B 10/10/10
enter code here
In B1 add
=A1 & "/" & A1 & "/" & A1
and drag down (from the cells bottom right corner).
1.4m articles
1.4m replys
5 comments
57.0k users
