Three Cells

Closed
arosa5 Posts 2 Registration date Monday October 13, 2008 Status Member Last seen October 15, 2008 - Oct 14, 2008 at 04:16 PM
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 - Oct 15, 2008 at 03:52 PM
Hello,

I need some support with creating a formula:

This is what I want the Cell to look like "200810131234ABC123456789"


Cell 1 contains 1234
Cell 2 contains 10/13/2008
Cell 3 contains ABC123456789

I want cell 3 to look like this 200810131234ABC123456789

Any support will be great.

Thank you.

3 replies

Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Oct 15, 2008 at 03:55 AM
Hello,
=YEAR(A2)*10000+MONTH(A2)*100+DAY(A2) & A1 & A3

Ivan
1
arosa5 Posts 2 Registration date Monday October 13, 2008 Status Member Last seen October 15, 2008
Oct 15, 2008 at 12:18 PM
Hello

Can I add static information in place of the "A3" such as ABC123456789

Thank you
0
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Oct 15, 2008 at 03:52 PM
Hello,
of course you can by using quotes
=YEAR(A2)*10000+MONTH(A2)*100+DAY(A2) & A1 & "ABC123456"

Ivan
0