I'm having trouble with concat.
The data I want to concatenate is comprised of a date and two values. When I formulate the function as I've done in the past, it doesn't produce what I'm expecting
I've attached a small worksheet which shows how the existing data is formatted, and to its right, my desired formulation.
I've tried various formulas along with Concat such as Text, but this results with the date being presented with the 5 digit date number rather than text.
Thanks for any help!
Bookmarks