Create unique numbering system from three bits of data
 

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

Create unique numbering system from three bits of data
 

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

"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

Create unique numbering system from three bits of data
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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

Create unique numbering system from three bits of data
 

Maybe this

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

which gives
0906235001001

and if you drag down 1 row becomes

0906235001002

Mike

"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

Create unique numbering system from three bits of data
 

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