macro to merge 3 cell into one cell

[pepdeal]

I need a macro to combine 3 cell data into one.

input:

A B C

34.98.76 : 78
67.76.987 : 75


output :


A B C d

34.98.76 : 78 34.98.76:78
67.76.987 : 75 67.76.987:75

[pepdeal]

here

input:

A | B | C

34.98.76 | : | 78
67.76.987 | : | 75


output :


A | B | C | d


34.98.76 | : | 78 | 34.98.76:78
67.76.987 | : | 75 | 67.76.987:75

[watersev]

hi pepdeal, whould that help?

Formula for D1

Please Login or Register  to view this content.

or VB option

Please Login or Register  to view this content.

[watersev]

if data starts in A1:C1 and down the following should help:

Please Login or Register  to view this content.