Create unique numbering system from three bits of data

[skimark]

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

 

[Eduardo]

Hi,
let's say you have the three numbers you want to combine in cells A1,A2 and A3
in B1 enter

=A1&A2&A3

if this helps please click yes, thanks

 

[Luke M]

You can concatenate different cells together with the ampersand like so:
=A1&A2&A3

Note that since you are dealing with numbers/dates, you may need to get a
little fancy so that data comes in correctly. May need:

=TEXT(A1,"yymmdd")&TEXT(A2,"0000"),&TEXT(A3,"000")
If you then need this forced back into number value, surround previous
formula with the VALUE function.

 

[Jacob Skaria]

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

 

[Mike H]

Maybe this

=TEXT(NOW(),"yymmdd")&5001&TEXT(ROW(A1),"000")

which gives
0906235001001

and if you drag down 1 row becomes

0906235001002

Mike