Hi,
try Ctrl + H
Replace wath : p
Replace with :(space)pm
Click replace or replace all
israel;375180 Wrote:
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
--
Pecoflyer
Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=105004