Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Input the text of a cell into a text only cell - text formul

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Atlanta
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi. I'm new to the board and thought I knew a lot about excel, only to find out I'm a mere beginner.

    I have a cell, we'll call it A1 that has the text "John Doe" in it. I have another cell in my sheet that has the text "_____'s Annual Costs". I want the blank to be the contents of cell A1 so whenever I change A1, it automatically updates the other cell. Basically this is a text formula. Is there a way to do this? I've been trying for months. Thanks.

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    = Sheet1!A1 & "'s Annual Costs"

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Atlanta
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perfect. Thanks for the help. I knew it had to be something simple.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just in case this for english class, you could use
    =PROPER(A1)&IF(RIGHT(A1)="s","' Annual Costs","'s Annual Costs")

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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