CODEWITHSUNDEEP
exceldategoogle-sheetsconcatenationgoogle-sheets-formula
Beardlongo
Beardlongo

Reputation: 69

(Google Sheet) Combine text and Date in Cell

I am trying to get a Summary of multiple Cells into one Cell (for later use in GCalender). Trying to Concatenate a Date results into #ERROR! and similar questions and results found online dont work at all.

Example Sheet

Expected result should be:

="anything "&C2& " - " &TEXT(E2,"dd/mm/yyyy")

=anything thishappens - 10/03/2020

But Quoting the date alone will result in just a number (43900), and the TEXT and DATE formate will not work as found online or examples by Google.

Upvotes: 0

Views: 908

Answers (1)

MattKing
MattKing

Reputation: 7773

It looks like you might be in Europe or somewhere where they use ; instead of , as the parameter separators in formulas. Try this:

="anything "&C2& " - " &TEXT(E2;"dd/mm/yyyy")

Upvotes: 2

Related Questions