How can I insert a character in a string using formula field

[NeoInJS]

How can I insert a character in a string using formula field. For example, my record is 1256. I want to have a formula to insert ':' to make it 12:56. I can do it using Left() and Right() functions, but cis there another function where I can use to insert a character?

[LunaLovegood]

Hello @NeoInJS,

You can use Stuff function. So in your case, please try: Stuff([@field:fieldname], 3, 0, ':')

— Luna —

[NailDyanC]

Just to add to this post, if you are thinking to what you should use in string manipulation workflows, you may go to Caspio's Function reference to check what functions you can use: 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 find the name', 'Remove name')