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