Merge mixed data - retain date/time formatting

[symaxf]

Hello again.

I would like a formula to merge the contents of the data in column A (Date), B, (Time), and D (Number) into column E, separated by a " | ", and keep the same Date/Time format. I've attached a sample worksheet and manually formatted the first 3 in column E.

Note: Col A & B will always contain data. Col D could be blank.

Any help will be much appreciated.

Thanks,

S.

[TonyS]

Hi,
Try this macro

Please Login or Register  to view this content.

Tony

[watersev]

hi, symaxf, please check attachment, I'm not sure it's the shortest way but it gives the desired result

[symaxf]

TonyS and waterserv - Thank you both! The macro and the formula worked as desired!

Cheers,

S.

[symaxf]

Not sure if I need to open a new thread for this but using the same test data attachment with the formula that watersev provided in post #3, how would I add the following to the formula:
IF column D ("ID") is BLANK (no data) THEN do NOT merge any data into column G.
-S.

[watersev]

hi, symaxf, it can be done like this, check attachment file

[symaxf]

Thanks again watersev - it works like a charm!

Cheers,

-S