Translate formulas from Excel to Zoho

Translate formulas from Excel to Zoho

So I have this excel file with some formulas. I was wondering if there is a way to translate them into Zoho. Not really sure if they will be a calculated fields or a script...I'm guessing a script.

Formula 1 - Cuts text at character 80. If string exceeds 80 characters it is cut.

Excel: LEFT(IF(A1),80)

Formula 2 - Combine two fields into one. Text Field and Numeric Field.

Excel: "TEXTFIELD1"&A1

Example:
TEXTFIELD1 = Forum
A1 = 13
Result: Forum13

Thank you for any suggestions. I really like Zoho.

Mike