Question: problem in dividing column A of both sheets into separate cells

Hi,

please help

a) "[=>]" to be substituted by ":"

b) content of column A (of both sheets 1 and 2 of the attached excel file) to be in separate cells (each word in a separate cell)

c) content of each separate cell then to be united again (without loss of the data)

i tried everything, but sadly hopeless.

how to do it ?

thank you very much in advance !

best regards