6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

How do you do this in a spereadsheet?

by Thomas
5 replies
Hello Warriors:

Does anyone know how you insert content from other cells into the content of a particular cell in a spreadsheet?

For example, if I wrote: "This X is very nice." into a cell, how can i make X automatically become whatever is written into another cell?

I have a vague memory of how to do it but just can't figure it out right now (or maybe my memory is just faulty and it can't be done?).

Does anyone know?

Thanks,
Tommy.
#spereadsheet
  • Profile picture of the author ebuyer123
    Originally Posted by Thomas View Post

    Hello Warriors:

    For example, if I wrote: "This X is very nice." into a cell, how can i make X automatically become whatever is written into another cell?

    Tommy.
    Excel equation:

    =CONCATENATE(A24," ",B24," ",C24)

    Say...
    Input at Cell A24 = Hello
    Input at Cell B24 = Tommy
    Input at Cell C24 = In Ireland

    The sentence will be: Hello Tommy In Ireland

    Hope this helps...

    ebuyer123
    Signature
    << FREE Credits for Content Facilitator Membership & FREE Account >>
    {{ DiscussionBoard.errors[872134].message }}
  • Profile picture of the author CDarklock
    In Microsoft Excel, you enter the cell reference as a formula. Like if your cell that said "This X is very nice." was K2, you would enter "=K2" in the other cell. See the image here:



    Notice that cell K2 contains the text, "This X is very nice." Cell F1 is selected, and also contains the test "This X is very nice." - but in the formula editor, you can see the formula "=K2", which means F1 will contain whatever text is in cell K2, even if the text in cell K2 changes.

    EDIT: I seem to have completely misunderstood the question. It's early, the kids won't shut up, I haven't had my coffee, and I'm retarded. Sorry.
    Signature
    "The Golden Town is the Golden Town no longer. They have sold their pillars for brass and their temples for money, they have made coins out of their golden doors. It is become a dark town full of trouble, there is no ease in its streets, beauty has left it and the old songs are gone." - Lord Dunsany, The Messengers
    {{ DiscussionBoard.errors[872138].message }}
  • Profile picture of the author WallerBlog
    You can use the CONCATENATE function to do this. Using your example, the syntax would be

    Code:
    =CONCATENATE("This is ",A1," very nice.")
    Just change A1 to whatever cell contains the information you are wanting to insert.



    Edit: Ebuyer123 replied quicker than I could.
    {{ DiscussionBoard.errors[872139].message }}
  • Profile picture of the author Thomas
    Ah, yes... concatenate... I knew it was soemthing I couldn't spell!

    Thanks guys. I really appreciate it.

    Regards,
    Tommy.
    {{ DiscussionBoard.errors[872168].message }}
  • Profile picture of the author Peter Bestel
    No Excel expert, but couldn't you also do this?

    ="This "&TEXT(B3,"")&" is really nice."

    So if cell B3 contained the word "product", the above equation would return, "This product is really nice"

    Peter
    {{ DiscussionBoard.errors[872183].message }}

Trending Topics