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.

1 response

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,".","")
0