Display text from another cell in excel

    display formula result in another cell
    excel display formula result in another cell
    excel show formula result in another cell
    show formula result as text in another cell
  • Display formula result in another cell

    • Excel formulatext to formula

  • Excel show formula result as text in another cell
  • Excel display text from another cell in another sheet
  • Excel formula output to another cell
  • Excel fill cell based on value of another cell

    • Excel display text from another cell in another sheet!

    Tap Alt+F11 and when the VBE opens, immediately use the pull-down menus to Insert, Module. Paste the following into the new pane titled something like Book1 - Module1 (Code), 
    Public Function udfShowFormula(r As Range) As String
        udfShowFormula = vbNullString
        If r.HasFormula Then udfShowFormula = r.Formula
    Copy or Fill Right or Down as necessary.

    Report abuse

    Harassment is any behavior intended to disturb or upset a person or group of people.

    Threats include any threat of violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.

    Excel show cell contents in formula bar

    Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising Any link to or advocacy of virus, spyware, malware, or phishing sites.

    Any other inappropriate content or behavio

      display formula in another cell
      show formula in another cell