Tips and tricks

Excel - how to add a string after 2 or 3 position in columns
Posted on May 9 2017 / in Tips

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

 

CATEGORIES
Tips
AUTHOR
admin
How to get all google fonts json via API
How to create custom layout in rows in Visual Composer

Leave a comment

Your email address will not be published

{"type":"main_options","images_arr":"'#ffffff'","bg_slideshow_time":"0","site_url":"https:\/\/digitalzoomstudio.net","theme_url":"https:\/\/digitalzoomstudio.net\/wp-content\/themes\/qucreative\/","is_customize_preview":"off","gallery_w_thumbs_autoplay_videos":"off","base_url":"https:\/\/digitalzoomstudio.net"}