Hello and Seasons greetings
I am importing a CSV into Excel and have come across 2 questions:

1 The spreadsheet is for transactions and there maybe more than one line
for a transaction. If there is more than one line there is some of the data
that is ommitted (Its the same as the first line for that transaction). I
need to copy the data from the first line into the second line. To further
complicate I need to concatenate 3 of these cells together, into a helper
cell. How do I do this?

2 One of the cells is Date/Time in the format yyyymmddhhmmES with no
delimiting characters. How can I convert this cell to mm/dd/yyyy hh:mm and
truncate the time zone?

Thanks for your help
Beth