How To trim?

[Karthick_Rajave]

Hello,

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

[Aleksi · 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.

[Karthick_Rajave]

Thanks… Its solved

[Aleksi]

You’re welcome