Excel help

Reply #7

SergeM — Fri, 24 Apr 2015 23:02:12 GMT

'={ !-- (SQRT(MOD(1/2*VALUE(TEXT(VALUE(CONCATENATE( A1, B1, C1)), 000 ))*2,1000))^2

Reply #6

winsumloosesum — Fri, 24 Apr 2015 21:25:46 GMT

A1= 1

B1= 2

C1= 3

=VALUE(CONCATENATE(A1,B1,C1

Reply #5

justawiner — Tue, 14 Apr 2015 15:48:43 GMT

simply do =CONCATENATE(A1, ,B1, ,C1) if your cell are A1 B1 C1. if not adjust accordingly.

Reply #4

SergeM — Mon, 13 Apr 2015 14:01:01 GMT

=A:A B:B C:C

Reply #3

phileight — Mon, 13 Apr 2015 01:22:31 GMT

Cell A2=1

Cell B2=2

Cell C2=3

Cell D2: =A2*100+B2*10+C2

Raven and Rackster another way would be in D2 =a2 b2 c2

Reply #2

Rakster — Sun, 12 Apr 2015 17:26:31 GMT

Thank you Raven

Reply #1

Raven62 — Sun, 12 Apr 2015 17:05:19 GMT

Cell A2=1

Cell B2=2

Cell C2=3

Cell D2: =A2*100+B2*10+C2

Excel help

Rakster — Sun, 12 Apr 2015 16:58:03 GMT

I tried searching this and couldn't find what I was exactly looking for...

I got 3 numbers in 3 seperate columns.... I want to put them all together into 1 column.

Example

| 1 | 2 | 3 | ----- | 123 |

Is there a formula for this? And if so, can it be done for an entire row at one time or individually?

Thanks