Your description is none too clear.

Please re-post with another try at showing what you have and what you want.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 07:28:01 -0800, 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.