Merging 2 Points of Data from 2 cells into one String

[popcornrulez]

Is there a formula for taking two cells and merging the data. Here's and example of what I want to do: A1="00000080" without quotes and B1="7652" without quotes. I want a formula that when I put the formula in C1 I want C1 to equal "000000807652" without quotes.

Any help with this would be greatly appreciated.


popcornrulez

 

[RonB1111]

=a1&b1

 

[Vanda_a]

Is there a formula for taking two cells and merging the data. Here's and example of what I want to do: A1="00000080" without quotes and B1="7652" without quotes. I want a formula that when I put the formula in C1 I want C1 to equal "000000807652" without quotes.

Any help with this would be greatly appreciated.


popcornrulez

<colgroup><col width="64"></colgroup><tbody>
</tbody>

=CONCATENATE(A1,B1)

 

[popcornrulez]

Both of your formulas worked to an extent, I would like somebody to look at this spreadsheet I have in my dropbox:

https://www.dropbox.com/s/tqhts4optqj161k/My Spreadsheet.xlsx

 

[RonB1111]

=text(c2,"0000000000000000")&e2

 

[popcornrulez]

=text(c2,"0000000000000000")&e2

Thanks Ron! That helped me a lot!

popcornrulez

 

[RonB1111]

You're welcome. Thank you for providing feedback.