Kindly Help me on Macros

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use formula

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