If you actually see:

11:22:33AM

in a cell, then in another cell:

=LEFT(A1,8) & " " & RIGHT(A1,2)

--
Gary''s Student - gsnu200774


"dwny" wrote:

The Time stamp data that comes to me is in this format hh:mm:ssAM, and to
use the data I need to put a space between the seconds and AM (or PM). Doing
this manually is grueling so I recorded a macro but the macro changes the
data to the data in the cell in which it was recorded. So I'm not sure what
the right solution is and appreciate any guidance. Thank you. Doug