Help ~ conversion

Dear all

Please help me regarding this case ...

Column Column Column Column Column
A1 B1 C1 D1 E1
1 2 3 4 Result ?

Please help .. how can I display those numbers from column A1 B1 C1 D1
to the Column E1 just in one cell ..

Example : E1
1234

Thanks in advance ...

Originally Posted by sricomm

Dear all

Please help me regarding this case ...

Column Column Column Column Column
A1 B1 C1 D1 E1
1 2 3 4 Result ?

Please help .. how can I display those numbers from column A1 B1 C1 D1
to the Column E1 just in one cell ..

Example : E1
1234

Thanks in advance ...

in E1 put

=A1&B1&C1&D1
or
=CONCATENATE(A1,B1,C1,D1)

Regards.

Originally Posted by starguy

in E1 put

=A1&B1&C1&D1
or
=CONCATENATE(A1,B1,C1,D1)

Regards.

dear starguy .. thanks for your tips ..really appreciate it ..

Originally Posted by sricomm

dear starguy .. thanks for your tips ..really appreciate it ..

you are welcome and thank you for the feedback.