CREATE QUOTE NO

  • Thread starter Thread starter Stuart WJG
  • Start date Start date
S

Stuart WJG

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
 
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
 
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
 
Hi

=C1 & B1

Regards,
Per

Stuart WJG said:
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
Click to expand...
 
Whatever you decide, you may want to keep leading 0's:

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

It'll may make sorting much easier.
 
Back
Top