How to remove a space?


I display customers like this Mr John Smith. However, the first name is optional and if a user only enters Mr Smith then I have two spaces, Mr Smith.

This is because the first name (which is not shown( has a space before and after. I wondered if there’s a neat way to solved this without a conditional?

Replace Thing's First Name with this:

Thing's First Name:is not empty:format as text
For “yes” do Thing's First Name (with a trailing space)
For “no” leave it blank

Then remove the space you manually typed between
Thing's First Name and Thing's Last Name

1 Like

That’s a great solution, perfect! Thank you so much :slight_smile:

1 Like