Excel Spreadsheet

[Curious1]

I am trying to find out how to perform this excel spreadsheet function.
enter the below data in cells A1 & B1

A1: look see: how, to, run, fast
B1: all::1:0:|all::2:0:|all::3:0:|all::4:0::

How do I acquire this final result in cell B1?

B1: all:how:1:0:|all:to:2:0:|all:run:3:0:|all:fast:4:0::

Can anyone help me on this one? you're much appreciated

Curious1

 

[knight00779]

Hi,

Have you tried concatenate function of excel.

rgrds
Manohar