• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A simple formula

  • Thread starter Thread starter Pampos
  • Start date Start date
P

Pampos

Guest
Hello. For example, if in cell C2 put the formula =A3 then the cell show what is in A3. But I want to have words with the formula. For example is in A3 I have the word "dog", I want in C2 to write "My animal is A3" and to show "My animal is dog". Is that possible?
 
Is there another way to have a big text and to put inside the text =A3, =B2, =C4 ?
 
I want to have on a cell:
The sum is "A3", the difference is "B3", the "product" is "C4".
 
@Pampos

'&' is a concatenate operator. You can use it with string like ="First Name"&"Last Name" will produce First NameLast Name in cell or ="First Name "&"Last Name" will give First Name Last Name.

This can also be use to connect formulas with formulas or strings. Say ="The weeknumber is "&WEEKNUM(A3,1) with date in A3 will result in The weeknumber is #.

Regards,
 
You must log in or register to reply here.
Back
Top