how to create formula.
 

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.

how to create formula.
 

I'm afraid your question is not clearly stated. Can you try describing what
you have, and what you want to happen to it, in more detail please?

Rick


"Johnny" wrote in message
...
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.

how to create formula.
 

"Rick Rothstein (MVP - VB)" wrote:

I'm afraid your question is not clearly stated. Can you try describing what
you have, and what you want to happen to it, in more detail please?

Rick


"Johnny" wrote in message
...
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 1
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.

how to create formula.
 

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.

how to create formula.
 

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.