3 cells data into 1 cell

[homboy27]

68 92 38 689238
36 94 23
38 66 23
29 64 02
38 84 04
36 76 74
36 66 67
38 56 13
28 58 43
38 44 72
36 66 78
42 72 07

i have numbers in 3 different cells, how do i make them in one cell, like the first one
thanks

[FDibbins]

Hi and welcome to the forum

Administrative Note:

• We would love to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread title
• Please PM me when complete and this post will be removed which will reset the replies to zero…
  
  To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
  
  (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Tony Valko]

Try something like this...

=A2&B2&C2

That will return the cell contents as a TEXT string.

If you want the string to still be a numeric value then try this version:

=--(A2&B2&C2)

[Patty McJorst]

You would want to use the concatenate formula.

Assuming your example is cells A1 through C12, and you want to put the combined number in row, you can type the following formula in cell D1:

=CONCATENATE(A1,B1,C1)

This can then be dragged down to populate the other cells.

[homboy27]

None of these work

[Tony Valko]

Can you be more specific?

What kind of result do you get? Do you get an error?

[Patty McJorst]

Can you be more specific?

What kind of result do you get? Do you get an error?

Maybe provide your spreadsheet?