Forum Discussion
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,
- =REPLACE(REPLACE( a1:a10 ,7,0,"/"),2,0,"/")
replace a1:a10 with the range you need
2 Replies
- =REPLACE(REPLACE( a1:a10 ,7,0,"/"),2,0,"/")
replace a1:a10 with the range you need- 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...
