How To trim?

Hello,

After conditions checked, Initial value is returning as GT4,. How to trim theses quotes. I want only value.

2X_c_c2cd9461832f7be7c7723265cef050abc5120e02.png

Solved Solved
0 3 557
1 ACCEPTED SOLUTION

If the value is always the first one, you can use INDEX(SPLIT(“GT4,”,","),1) Instead of using “GT4,”, you need to use what ever formula you are using for that value.

View solution in original post

3 REPLIES 3

If the value is always the first one, you can use INDEX(SPLIT(“GT4,”,","),1) Instead of using “GT4,”, you need to use what ever formula you are using for that value.

Thanks… Its solved

You’re welcome

Top Labels in this Space