Replace and Split Excel value

Help Studio
4

Here’s how to solve it:

  1. Use a Contains inside an if statement to see if your value contains a dot and if it does, replace it with a comma.
  2. Use a EndsWith inside an if statement to see if your value ends with 0 and if it does, use Remove(yourStringLength - 1, 1) to remove it.
2 Likes