Forum Discussion

Picolomini's avatar
Picolomini
Copper Contributor
May 21, 2022
Solved

How to insert a slash in the same position in a text in cells of a entire column?

Example: 50018522 to 5/00185/22.    How to insert slashes after all rows of a column have been fulfilled like the example above?   Tks,
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 21, 2022
    =REPLACE(REPLACE( a1:a10 ,7,0,"/"),2,0,"/")
    replace a1:a10 with the range you need
mtarler's avatar
mtarler
Silver Contributor
May 21, 2022
=REPLACE(REPLACE( a1:a10 ,7,0,"/"),2,0,"/")
replace a1:a10 with the range you need
  • Picolomini's avatar
    Picolomini
    Copper Contributor
    May 22, 2022
    Mtarler,

    Absolutely right! Thanks a lot.
    I was imagining to copy the column to a notepad and after that paste in Excel as delimited columns, adding slashes with "&" and finally concatenate all three columns... Too much burocratic...

Resources