BookmarkSubscribeRSS Feed
MelissaN
Obsidian | Level 7

I would like to concatenate 2 variables and format as A - B.

I used cats(A,' - ', B), but the result was A-B (no space between the letters and the dash).

I also tried cats(A, ' ' , '-', ' ', B), but it still returned A-B

Is there any way to add a space between them?

Any help is greatly appreciated.

2 REPLIES 2
novinosrin
Tourmaline | Level 20

Try



catx('  -  ',A,B)
ballardw
Super User

From the documentation for CATS:

Removes leading and trailing blanks, and returns a concatenated character string.