INSERT FUNCTION

[Arjun_Kshirsagar]

In the inser function , there is not available concatenate option for making formula 

please provide us.

[#2]

Concatenate function available in the COMPATIBILITY function. you can also try CONCAT function from TEXT function. If you are using M365, you can try TEXTJOIN function from TEXT function.