remove all blanks in text from excel

[ciriastorres]

I am comparing two texts, one of them since Excel, it brings me spaces at the end, I tried with trim but it does not work, the text is something like this "text "

[yashag2255 · Accepted solution]

Hi @ciriastorres 

You can try using the replace function. 

replace(excelcolumnhere,' ','')

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!