software

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

you could move them with code and a change event .Prolly simpler to just show
them,in e1 type =concatenate(A1,B1,C1) or =A1amp;B1amp;C1.Use a quot; quot; if you want a
space
--
paul
remove nospam for email addy!
quot;Lilliequot; wrote:

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

=A1amp;B1amp;C1

if you want a space in-between

=A1amp;quot; quot;amp;B1amp;quot; quot;amp;C1

--
Regards,

Peo Sjoblom

(No private emails please)quot;Lilliequot; gt; wrote in message
...
gt; Excel 2003: What is the formula for moving the contents of 3 cells, A1:C1,
gt; into 1 cell, E1?