Use Edit | Find & Replace?
Find: p <with no leading space
Replace: PM <with a leading space
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"israel" wrote in message
...
Hello all,
I ran into a problem with my spreadsheet, can anybody help?
I have a cell that reads time as follows "01:23p". I'm in desperate need
to edit the cell by adding a space before the letter "p" and add the
letter
"m" after the letter "p".
Is there a way to complete this task. I appreciate your response.
Thank you
--
smile