hello expert,
i am trying swapping text in column "F", Wherever is a "SR" text, there should be "SL" text and where is "SL", there should be "SR".
Please help me by giving vba code.
hello expert,
i am trying swapping text in column "F", Wherever is a "SR" text, there should be "SL" text and where is "SL", there should be "SR".
Please help me by giving vba code.
Can be done with FIND & REPLACE.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Mumps1,
Thanks a lot it's working very well.
Another choice:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sorry alansidman,
But did you test the code? This code is not working properly, but thanks for your code.
try this instead
Please Login or Register to view this content.
alansidman
Thank you very much Sir, this code is working awesome.
Glad to be of help.
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks