Question

how text formula is created​

Answer 1

Select all the cells with formulas that you want to convert. Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard. Press Shift + F10 and then V to paste only values back to Excel cells. Shift + F10 + V is the shortest way to use Excel "Paste special - values only" dialog.

I hope it will help you.

Answer 2

Answer:

Text formula is formed by following these steps :-

1.Select the cell in which you want the combined data.

2.Type the formula, with text inside double quotes. For example: ="Due in " & A3 & " days" NOTE: To separate the text strings from the numbers, end or begin the text string with a space.

3.Press Enter to complete the formula.

Hope this will helpful to you