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