how can accomlish this task? When I type text in column A, it appears in
column B automatically in the following format, see below:

column A
<babc rugs<brcolors:red, blue<br size: 2

column B
colors:red:1:1:0:|colors:blue:2:0:0: