Forum

Replace Multiple Va...
 
Notifications
Clear all

Replace Multiple Values

4 Posts
2 Users
0 Reactions
54 Views
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi,

Attached macro work to replace Column I values by Column J in Column A

Ex: 

Column A: Ándre Oliveira

Column I: á

Column j: a

So macro result is andre Oliveira

Please I want to add character sensitive in macro, to don't replace small characters by upper characters or upper characters by small characters.

So in above case, the macro result will be Ándre Oliveira without any change.

Please check attached macro.

Thanks;

Marsil

 
Posted : 23/01/2021 7:00 pm
(@catalinb)
Posts: 1937
Member Admin
 

2021-01-23.png

Hi Marsil,

The Replace method has more arguments, one of them is MatchCase, that's what you should use.

 
Posted : 24/01/2021 5:02 am
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi Catalin,

Thanks a lot. It works now.

Thanks;

Marsil

 
Posted : 24/01/2021 9:35 am
(@catalinb)
Posts: 1937
Member Admin
 

You're welcome 🙂

 
Posted : 24/01/2021 12:13 pm
Share: