Previous Topic Next Topic

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 responses

Answer 1 / 3
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
Answer 2 / 3
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
Answer 3 / 3
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Comparing columns and returning value
ll -
kittu -

35 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses