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))

LaurieATX

Copper Contributor

Jun 10, 2020

Hi Alan. Thanks for your reply! It worked, but it shows it is 1-2, instead of Jan 2 on my first entry.

rvann
Copper Contributor
Jun 10, 2020
LaurieATX
Try this: =(A1&" "&B1&" "&TEXT(MONTH(C1),"mmm")&"-"&DAY(C1))
- LaurieATX
  Copper Contributor
  Jun 10, 2020
  That worked. Thank you! rvann
- Charla74
  Iron Contributor
  Jun 10, 2020
  rvann @LaurieATX
  
  I concur. 🙂