Results 1 to 2 of 2

Thread: I need help with a text formula

  1. 30-08-2010 #1
    Len Cobb
    Len Cobb is offline Member
    Join Date
    Aug 2010
    Posts
    1

    I need help with a text formula

    I want to know how to create a formula that will display a text phrase 'anything' in cell C2 when a user types anything in cell B2.
    Reply With Quote Reply With Quote
  2. 31-08-2010 #2
    Orlando
    Orlando is offline Member
    Join Date
    Feb 2009
    Posts
    673

    Re: I need help with a text formula

    If am right, you mean to say that the Cell C2 should display the exact thing that is in Cell B2, right ? If it is yes than its very simple. You just have to enter = sign and select the Cell B2. Thats it ! Select as much row you wanna display in C column.
    Reply With Quote Reply With Quote
« cannot open any file in administrative rights | OpenSSH on windows 2003 »

Similar Threads

  1. Looking for formula that can ignore text values in Excel
    By Henriksen in forum MS Office Support
    Replies: 3
    Last Post: 23-02-2012, 07:20 PM
  2. How to put formula in Text Box in Microsoft Excel
    By TheCarter in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 05:58 PM
  3. Convert copy formula to Text in Microsoft Excel
    By Kaesav in forum MS Office Support
    Replies: 2
    Last Post: 01-02-2012, 07:39 PM
  4. How to change cell formula to text in VBA
    By Chhaya in forum Software Development
    Replies: 3
    Last Post: 08-05-2009, 12:12 PM
  5. Text not visible in cell only in Formula Bar (excel 2003)
    By NavinS in forum MS Office Support
    Replies: 1
    Last Post: 14-02-2008, 03:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Page generated in 1,713,538,983.04013 seconds with 17 queries