replace text

[charm1]

Hi Excel Gurus,

I have a worksheet where I need to change text into specific letter, for this i use

Please Login or Register  to view this content.

formula concatenated for each text which need to change, sometimes there are so many formulas which gets concatenated and it makes worksheet performance very slow. I have attached a sample worksheet for your reference. is there any VBA solution for this to improve the performance of worksheet. it would be great if macro runs every time if anything changed in the sheet.

[Sintek]

Hi charm1

Might be an easier solution????
Put this in Sheet1.Module

Please Login or Register  to view this content.

And this in a std module

Please Login or Register  to view this content.

Enter your Original text characters into any cell in Range("B11:I17")

[charm1]

Hi sintek,

Many thanks for looking into this and providing a VBA solution. your macro works perfectly and it has indeed improved the worksheet performance when I tested with a range of 26 characters (A1.... Z1) and also got reed of concatenating so many formulas in once cell, however it stoped working when I changed the characters from "A1...Z1" to "A....Z", I have attached a sample workbook for your reference. It would be great if you provide a solution for this in the same code.

Thanks,
Charm

[Sintek]

Change this line of code....

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.