editing a cell with time

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

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
 
Use worksheet menu Edit - Replace

highlight celss or columns that need replacement

from: p
to: pm (put a space before the P in the to box)
 
Use Edit | Find & Replace?
Find: p <with no leading space>
Replace: PM <with a leading space>

best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cell based on uppercase letter 2
Two conditions in one cell. Help needed ASAP 3
Excel Use COUNTIF across a range of cells with formulas 0
Adding Cells with a letter in one of them 3
Editing cell names 1
Add a formula to and existing formula 11
Can i count how many letters A from cell e10 to sell h10 ? 1
Excel Add ^ to a row of cells containing letters 3

Back
Top