Just use the old good copy paste way. IF Sheet1A1Sheet1A1 If this answer solves your problem please check Mark as Answered. Do one of the following.
Click the bottom part of the Paste button on the toolbar to reveal more options.
Now all you need to do is press CtrlV to paste the format code into your TEXT formula like. Press CtrlC to copy the format code then press Cancel to dismiss the Format Cells dialog. Click the cell with the formula to select it. Putting your cursor at the right-lower corner of the cell F2 till it becomes a small black cross.