Try the below in cell A1 and copy that down.
=TEXT(TODAY(),"yymmdd")&"5001"&TEXT(ROW(),"000")


Or

With your data if you have Date,Code and sequence in 3 cells use concatenate
to merge that together
A1 = Date
B1 = Code
C1 = Sequence
In D1
= A1&B1&C1


If this post helps click Yes
---------------
Jacob Skaria


"skimark" wrote:

Hi - I am looking to create a customer numbering system from three bits of
data - Firstly the date - secondly an advisor i/d number and thirdly a
sequence of numbers.

I can creat all three individually easily enough and have them in different
cells, but can anyone help me get all three into one cell afterward

The three peices of info would look like - 090623 (date)
Advisor i/d 5001
Customer number 001

and the resultant number would be 0906235001001

Many thanks