Hello,
I have the following in Column A
url.com?valueA
url.com?valueA&valueB
url.com?valueC
I need a function that
1. If string "ends with" valueA or ValueC, then replace it with ValueD
Hello,
I have the following in Column A
url.com?valueA
url.com?valueA&valueB
url.com?valueC
I need a function that
1. If string "ends with" valueA or ValueC, then replace it with ValueD
You can use an Update Query to do that.
Just create a simple Select Query using Criteria that only returns the values you want to update.
Then change it to an Update Query and add the value you want to change it to on the "Update To" line.
perfect....thanks alot