Add comma, period, equal sign or ! in a formula field

[mrsuave]

Hello forum people, is there any way that we can add some punctuation marks in two fields? Basically, I am joining two fields and wanted to add an '=' sign in between the fields and It is not working on my end. I have followed the steps in the article but still doesn't work. Can anyone help me out? Thanks! 

Lastly, this is want my current formula looks like : [@field:Media] +' Space(=)' + [@field:Other] 

Any suggestion/recommendations will do.

[RuisiHansamu]

Good day, mate! I see that you are trying to add a mark in between the joined fields. I have a formula similar to this one. Feel free to use this formula as your reference below: 

[@field:lastname] +' = '+ [@field:Name] 

Note: It could also be used with a comma, period or exclamation mark as well ( ' , ' , '. ', '!') Just simply change the = sign in the middle of the single quotes. 

Here is a sample result on my end. 

Cheers mate!  

[Flowers4Algernon]

Just wanna add this Caspio Article regarding Formula Fields: https://howto.caspio.com/tables-and-views/data-types/formula-fields/

[ParkLoey]

Also adding this function reference article to see which functions can be used in formula fields: https://howto.caspio.com/function-reference/

[Kurumi]

Hi! Just wanted to share this solution if you want to read or accept the single quote or apostrophe (') in the formula: https://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-a-single-quote-in-mysql

Example:

Replace([@field:FIELDNAME], 'Can''t found the name', 'Remove name')