VBA code for changing capital letters become lower

Jasa P · #3 04-19-2012, 09:46 PM

Quote:

Originally Posted by macropod

Hi Jasa,

You can do it without a macro, using a wildcard Find/Replace, where:
Find = ([0-9])[Xx]([0-9])[Xx.]([0-9])[Xx.]([0-9])
Replace= \1x\2.\3.\4

Hi, thanks a lot for helping me. Yeah, you are totally right and it can be done with Find and Replace. But, sometimes the data has 4 or more of "x".
Ex:
B3^t739X93.12.2.49.94 ---> 739x93.12.2.49.94
B4^t249.49.94x230x30x5x2165x5x5 ---> 249.49.94x230.30.5.2165.5.5

Would you mind to help? maybe it's better in macro

Thank u so much

Regards,

Jasa

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converts the words to actual All Capital Letters not workin macro??	powerdrum	Word VBA	2	12-08-2011 05:06 PM
Why the "Headings" are appearing in capital letters in the Table of contents?	Jamal NUMAN	Word	1	05-31-2011 08:31 AM
Search for paras beginging with a lower case	MShroff	Word	1	10-19-2010 06:41 AM
Code for Changing Cell Backgrounds	leroytrolley	Excel	2	12-05-2008 02:05 AM
Upper to lower case	jd	Excel	1	04-28-2006 07:40 AM