Custom text after number

Hi

In Excel, you could set a column to add text after a number i.e. 6 mm or 7 metres.

I would like to be able to do this in Coda, is it possible?

I have a table that pulls in data from other tables and although the qty column works, it would be nice to be able to let the user know the what the number is for.

i.e.
4 Hours
4 mm
4 miles

Hi @Juanmata

Rather simple, pls find the sample below :handshake:

Hello! It looks like the embed doesn’t work anymore and I am curious how to put custom text after a number.

Thank you!

Hey there!

Coda has a formula called Concatenate() - I like to think of it as the “Smoosh stuff together” formula.

So what you would do is simply create a new column that would smoosh your number and ending together.

  • Column 1: Number
  • Column 2: Number + ending

Formula
Concatenate(Number, “ “, ending)

There is also the format() formula which works a bit differently but can get you the same result

1 Like

@Scott_Collier-Weir thank you very much!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.