Inserting a space between #'s and text within a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have downloded information into excel and in one column I have the time but it written as 01:53PM and in order for my formulas to work I need a space between 01:53 & PM. Is there a formula to help be change the entire column? There are over 800 entries. I hope this makes sense. Thanks.
 
Try this:

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

The run the formula down your list.

Hope this helps
B
 
what is your formula?

--
Don Guillett
SalesAid Software
(e-mail address removed)
anj said:
I have downloded information into excel and in one column I have the time
Click to expand...
but it written as 01:53PM and in order for my formulas to work I need a
space between 01:53 & PM. Is there a formula to help be change the entire
column? There are over 800 entries. I hope this makes sense. Thanks.
 
Back
Top