-1

I'm using the following formula to get the data of two cells:

=CONCATENATE(C2,"Dia",E2)

But it's not working properly. Take a look at the screenshots:

It should be returning the Traffic + Date, but it's returning a value that I can't recognize.

So far, without joining both cells data, this is what I've achieved and what I need to achieve:

Also I'd like to know if there's a way to merge two cells of another spreadsheet using a formula like this: ='90diasnameone'!B16 + ='90diasnametwo'!C116 (I have no idea on how to do that, that's just an approach)

I already know how to display data in the graphic, so basically I'm just asking how to join two cells data into one cell. Something like: Julia + Maria = Julia and Maria.

EDIT: I managed to get the result of joining both data, but this is how it's appearing on the graphic:

enter image description here

As you can see, the date is appearing below the graphic and the data inside the graphic is messed up.

  • 1
    As questions post on this site should contain only one question, please move the second question to a new post. Reference How to Ask. – Rubén Mar 2 '18 at 0:44
  • It's the same thing, just a little deeper. – 023023 Mar 2 '18 at 4:37
3

Date is a number. It's the number of days from Jan 1899. It's just formatted to look like yyyy-mm-dd. To get displayed value instead of actual value, use TO_TEXT

=CONCATENATE(C2,"Dia", TO_TEXT(E2))

Concatenate will work across different sheets.

  • Do you know where I can find a list with all the commands? – 023023 Mar 2 '18 at 1:14
  • Your solution works by the way. I've used =CONCATENATE('90diaspessoas'!B16," ", TO_TEXT(E2)), worked like a charm. Can you please update with the code I've just written here as the answer to my second question where I said "=CONCATENATE('90diaspessoas'!B16," ", TO_TEXT(E2))"??? – 023023 Mar 2 '18 at 1:16
  • I got it to work, but now I have another problem, I'll update my question. – 023023 Mar 2 '18 at 4:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.