Excel 2003: What is the formula for moving the contents of 3 cells, A1:C1, into 1 cell, E1?
L Lillie Jan 4, 2006 #1 Excel 2003: What is the formula for moving the contents of 3 cells, A1:C1, into 1 cell, E1?
P paul Jan 4, 2006 #2 you could move them with code and a change event .Prolly simpler to just show them,in e1 type =concatenate(A1,B1,C1) or =A1&B1&C1.Use a " " if you want a space
you could move them with code and a change event .Prolly simpler to just show them,in e1 type =concatenate(A1,B1,C1) or =A1&B1&C1.Use a " " if you want a space
P Peo Sjoblom Jan 4, 2006 #3 =A1&B1&C1 if you want a space in-between =A1&" "&B1&" "&C1 -- Regards, Peo Sjoblom (No private emails please)
=A1&B1&C1 if you want a space in-between =A1&" "&B1&" "&C1 -- Regards, Peo Sjoblom (No private emails please)
