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?

  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.