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
--
paul
remove nospam for email addy!



"Lillie" wrote:

Excel 2003: What is the formula for moving the contents of 3 cells, A1:C1,
into 1 cell, E1?