This is what I need after run the formula.
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
USER W01
USER W02
USER W03


"Johnny" wrote:

Hi
any one know how to create a formula to replaced under cell A 11, 12 to any
text and cell B to any number or text I need.
sample below:
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.