if cell a1 is,abc. cell b1 is,10. cell c1 is ,de1.
can i get a another cell to give answer, abc10de1
excelent - 13 Aug 2006 20:25 GMT
=a1&b1&c1
"swain.s@blueyonder.co uk" skrev:
> if cell a1 is,abc. cell b1 is,10. cell c1 is ,de1.
> can i get a another cell to give answer, abc10de1
Gord Dibben - 14 Aug 2006 02:43 GMT
In D1 enter =A1&B1&C1
Gord Dibben MS Excel MVP
>if cell a1 is,abc. cell b1 is,10. cell c1 is ,de1.
>can i get a another cell to give answer, abc10de1