Forum Discussion

Copper Contributor

Jun 10, 2020

Solved

Concat combo of text and date

Hi all. I am trying to make a 4th column that has first name (a1), last name (b1) and DOB (c1), but only show the date in "Month Day" format. I am using =(A1&" "B1&" "C1) but it is returning the date...

Formulas and Functions

office 365

rvann
Jun 10, 2020
LaurieATX
Try this: =(A1&" "&B1&" "&TEXT(MONTH(C1),"mmm")&"-"&DAY(C1))

Charla74

Iron Contributor

Jun 10, 2020

It's a bit long winded and someone may be able to offer a better solution but you could try something along the lines of...

=(A1&" "&B1&" "&MONTH(C1)&"-"&DAY(C1))