User Profile
LaurieATX
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
- 1.2KViews0likes0Comments
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!Solved1.3KViews0likes5Comments
Recent Blog Articles
No content to show