I have in C1 a 3 letter text format eg WJT. In A1 I would like to create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£ WJT3 etc
etc
What di i need to do to dreate

Many thanks

Hi.

Put this in A1 and drag down

=$C$1&ROW()

Mike

"Stuart WJG" wrote:

I have in C1 a 3 letter text format eg WJT. In A1 I would like to create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£ WJT3 etc
etc
What di i need to do to dreate

Many thanks

Hi

Use this in A1 and copy down:

=C1&CELL("row";A1)

If the result always should depend on the value in C1, you need an absolute
reference:

=C$1&CELL("row";A1)

Hopes this helps.
....
Per

"Stuart WJG" skrev i meddelelsen
...
I have in C1 a 3 letter text format eg WJT. In A1 I would like to create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£ WJT3
etc
etc
What di i need to do to dreate

Many thanks

I should have added that if you use this fromula

=$C$1&ROW(A1)

then it doesn't have to go in A1, you can put it anywhere and drag down and
you will get your number suquence.

Mike

"Mike H" wrote:

Hi.

Put this in A1 and drag down

=$C$1&ROW()

Mike

"Stuart WJG" wrote:

I have in C1 a 3 letter text format eg WJT. In A1 I would like to create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£ WJT3 etc
etc
What di i need to do to dreate

Many thanks

Great that works. If I wanted to to put my own nos in sas B1 etc, What would
the formula in A1 to pick up the text in C1 (WJT) and the no in B1 (567) to
give WJT567

"Mike H" wrote:

Hi.

Put this in A1 and drag down

=$C$1&ROW()

Mike

"Stuart WJG" wrote:

I have in C1 a 3 letter text format eg WJT. In A1 I would like to create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£ WJT3 etc
etc
What di i need to do to dreate

Many thanks

Hi

=C1 & B1

Regards,
Per

"Stuart WJG" skrev i meddelelsen
...
Great that works. If I wanted to to put my own nos in sas B1 etc, What
would
the formula in A1 to pick up the text in C1 (WJT) and the no in B1 (567)
to
give WJT567

"Mike H" wrote:

Hi.

Put this in A1 and drag down

=$C$1&ROW()

Mike

"Stuart WJG" wrote:

I have in C1 a 3 letter text format eg WJT. In A1 I would like to
create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£
WJT3 etc
etc
What di i need to do to dreate

Many thanks

Whatever you decide, you may want to keep leading 0's:

=$c$1&text(row(),"000000")

It'll may make sorting much easier.



Stuart WJG wrote:

I have in C1 a 3 letter text format eg WJT. In A1 I would like to create a
quote no using whater ever text is in C1 eg WJT1.
In a2 I would like to the quote to do the same but be eg WJT2 in A£ WJT3 etc
etc
What di i need to do to dreate

Many thanks

--

Dave Peterson