Concatenation

[JPS]

HELP! I am concatenating five columns of data into one column and dates are
in two of the columns. The concatenated column displays the numeric date
value from the source column, and I need the date in the concatenated column
to show as mmm-yyyy.

 

[T. Valko]

Use this on the dates:

TEXT(A1,"mmm-yyyy")

 

[JPS]

T.
I knew this was a simple solution... As always I appreciate help from the
"experts"

 

[T. Valko]

You're welcome. Thanks for the feedback!