Notifications
Clear all
VBA & Macros
4
Posts
2
Users
0
Reactions
54
Views
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
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
Topic starter
Hi Catalin,
Thanks a lot. It works now.
Thanks;
Marsil
Posted : 24/01/2021 9:35 am
You're welcome 🙂
Posted : 24/01/2021 12:13 pm