Solved

How to convert a date value in an Excel 2003 file that is presently separated out into 4 columns (C thru F) so that it is consolidated into column C?

Posted on 2013-07-02
1
341 Views
Last Modified: 2013-07-02
How to convert a date that is presently separated out into 4 columns so that it is consolidated into column C?
I am working with an Excel 2003 file. Attached are sample records from the Excel file.
For the rows after the header, I would like to convert the values in:

columns C, D,E,F into column C.

Thus, the first record would be changed from:

Col A        Col B        Col C         Col D       Col E        Col F

5454        UNA          Jan              10             2013          9:26AM

Revised value for first record:

Col A        Col B        Col C

5454         UNA         Jan 10 2013 9:26AM
Test3.xls
0
Comment
Question by:zimmer9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
EuroHammer earned 500 total points
ID: 39293035
If you insert a column into C then paste the formula into C2 (assuming you have headers in your file) =CONCATENATE(D2," ",E2," ",F2," ",G2) not sure if this is what you are after.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question