Keep text formating with concatenate

[Filipa_Didier]

Hi all!

I have 4 tables that correspond to types of materials (Used dyestuff, Used fibers, …, …) with a column that concatenates information from other columns (a code, the material [Name], quantity, measurement and cost).

In a 5th table (My experiments & products) I need to pull that information from the 4 previous tables and concatenate it in one column.

I also reference this last column in the Canvas, in a formula for a Select control:

Why do I lose the bold text in the 5th table and in the Canvas formula?

Thanks!!

[Quentin_Morel]

Hello @Filipa_Didier

Welcome to CODA community !

You may consider using Format() function instead of Concatenate(). I cant take your full example now, but see in this very quick example that format is kept with Format() function :