Kindly Help me on Macros

Closed

Manoj - May 17, 2010 at 10:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 17, 2010 at 12:24 PM

Hi All,

Kindly provide me a Macro for find and replace for an X no of dots in to a single /

Example:

manoj..............Kumar
Rajesh.......................Kumar
Anil ....Muarli

I Need this on an Urgent basis . Kindly help me.

Regards,

Manoj.

Kindly Help me on Macros
Macros in excel download - Download - Spreadsheets
Do macros work in excel online - Guide
Excel macro to create new sheet based on value in cells - Guide
Unlock excel vba and excel macros - Guide
Excel run macro on open - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 17, 2010 at 12:24 PM

You can use formula

=SUBSTITUTE(A1,".","")

Similar discussions

Macro-Copy data from one workbook to another

Code for macro that conditionally inserts rows

One Button To Execute Two Macros

copy a row from one worksheet to another, based on criteria

Hi, I am a regular user of Facebook and suddenly my account was locked and i am

Similar discussions

Subscribe To Our Newsletter!