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 as a text coded date (ex 421993 format). The date is also being fed from another sheet in the workbook as well, so that may also be a contributing factor. Any ideas on how I can get it to show the date exactly as it appears in the sheet?

Thanks for your help!

excel

Excel for web

Excel on Mac

Excel on mobile

Formulas and Functions

office 365

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

5 Replies

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

Forum Discussion

Concat combo of text and date

5 Replies

Resources