Previous Topic Next Topic

Three Cells

Closed
arosa5 Posts 2 Registration date Monday 13 October 2008 Status Member Last seen 15 October 2008 - 14 Oct 2008 à 16:16
Ivan-hoe Posts 433 Registration date Saturday 16 February 2008 Status Member Last seen 17 October 2008 - 15 Oct 2008 à 15:52
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

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

Ivan
Réponse 2 / 3
arosa5 Posts 2 Registration date Monday 13 October 2008 Status Member Last seen 15 October 2008
15 Oct 2008 à 12:18
Hello

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

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

Ivan

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Arrow keys scrolling in Excel
Deb -
Upthewall -

24 responses
Excel function question
1234ah -
ac3mark -

3 responses