Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Why do you want to concatenate it, when you can use a Format Code like the following on your column?

M/DD/YYYY H:MM:SS AM/PM
  1. Select your column
  2. Right click for the context menu and select Format Cells...
  3. In the format code put something like the text above...the AM/PM part will display the AM or PM bit in every row but the header in your selected column after you press OK.