Merging Two Columns

A

abs

Using Excel 2003. Column A is a date and Column B is a time. I need the two
columns merged into Column C. Thank you.
 
W

woalmoore

By "merge" do you mean you need the strings concantenated?...i.e. 3/12/08 in
Column A and 3:46 in column B becomes 3/12/08 3:46?
 
F

FSt1

hi
if a is a date and b is a time then both are just numbers formated as data
and time.
a simple formula will combine them.
= a1+b2

regards
FSt1
 

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

sorting two columns of merged cells 1
counting blank cells within two columns 2
Merging multiple columns into one column (dynamically) 1
Merging two columns, data in one 7
Having Blank Cells, etc. ? 1
Changing the number of columns within existing column(s) 1
VBA- Excel Programming:- 0
Edit File Information 3

Top