How to remove tab spaces in text

Pallavi Kamath

Question

Before comparing the text, I need to remove the empty spaces in the text.

The problem that I am facing is, that the space before my text is a tab space.

question: How to remove any tab spaces in a text.

09 Mar 2020

Miguel Verdasca

Champion

There is a basic function that can remove all spaces.

Replace(t, search, replace)

Returns Text 't' after replacing all Text occurrences of 'search' with 'replace'.

Try it with search=" " replace=""

Or you can try one of the trim() functions.

09 Mar 2020

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.