With first name and last name in A1, date in A2, and
vendor name in A3, you could use:

=LEFT(A3,4)&LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)&TEXT
(A2,"yymmdd")

As an example, "Jason Morin", "3/28/2005", "Reynold's
Contstruction" would produce:

ReynJM050328

HTH
Jason
Atlanta, GA


-----Original Message-----
I am attempting to use a Purchase Order template for
employees and want the
template to automatically assign sequential PO numbers
by asking the employee
to enter a date, vendor name and their name on a second
worksheet within the
template. I would like any ideas on how other companies
have accomplished
this task.
.