Excel - how to add a string after 2 or 3 position in columns

Excel - how to add a string after 2 or 3 position in columns

You need to write this macro in Visual Basic

 

Sub replaceat()

Dim rng As Range Dim

cl As Range

Set rng = Range(Selection.Address)

 

For Each cl In rng.Cells

cl.Formula = “=Replace(“”” & cl.Value & “”” ,3,0,””.””)”

Next

End Sub

 

Then you can execute it on any selection via the Developer > Macros menu