merging 3 cells into 1 cell

[Pauls123]

Hi, I am new here and this is my first post. I'm also new at excel and trying to learn more. My first question is, say I have data in 3 cells, for example:

T1 the data says "RAND"

U1 the data says "1600"

V1 the data says "good"

Can I merge this into the next cell W1 so that it shows RAND1600good

Regards, Paul

 

[T. Valko]

Hi, I am new here and this is my first post. I'm also new at excel and trying to learn more. My first question is, say I have data in 3 cells, for example:

T1 the data says "RAND"

U1 the data says "1600"

V1 the data says "good"

Can I merge this into the next cell W1 so that it shows RAND1600good

Regards, Paul

Enter this formula in cell W1:

=T1&U1&V1

If you want spaces between words...

=T1&" "&U1&" "&V1

 

[Pauls123]

Thanks Biff, I am impressed, that reply was super fast, thanks again,

Paul

 

[hrayani]

Dear Pauls123

You can also use

Type in W1

without spaces

=CONCATENATE(T1,U1,V1)

With Spaces

=CONCATENATE(T1," ",U1," ",V1)

Humayun

 

[T. Valko]

Thanks Biff, I am impressed, that reply was super fast, thanks again,

Paul

You're welcome. Thanks for the feedback!