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

A

anj

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.
 
B

brianwa

Try this:

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

The run the formula down your list.

Hope this helps
B
 
D

Don Guillett

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.
 

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

How do I count the number of blank cells 0
How to ignore the in between cells? 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
Lookup and count all cells that fall between 2 dates 3
How do I set up a formula to give me an average based on IF? 1
Converting text format of time/date into Excel time/date for subtr 5
IF ARRAY with multiple conditions. 1
Page numbering with Merged Document and IF statements 1

Top